Overview

Dataset info

Number of variables119
Number of observations2025
Missing cells121313 (50.3%)
Duplicate rows0 (0.0%)
Total size in memory1.8 MiB
Average record size in memory945.1 B

Variables types

Numeric17
Categorical53
Boolean6
Date9
URL0
Text (Unique)0
Rejected34
Unsupported0

Warnings

2.1_Organization_Name has constant value "Family Promise of Spokane" Rejected
2.4_ProjectType has constant value "Emergency shelter" Rejected
2.5_Utilization_Tracking_Method_(Invalid) is a recoding of 2.2_Project_NameRejected
2.6_Federal_Grant_Programs has constant value "nan" Rejected
3.11_Exit_Date has 152 (7.5%) missing values Missing
3.12_Exit_Destination has 152 (7.5%) missing values Missing
3.16_Client_Location has 1432 (70.7%) missing values Missing
3.1_FirstName has a high cardinality: 1032 distinct values Warning
3.1_LastName has a high cardinality: 847 distinct values Warning
3.2_SocSecNo has a high cardinality: 989 distinct values Warning
3.2_SocSecNo has 835 (41.2%) missing values Missing
3.7_Veteran_Status has 992 (49.0%) missing values Missing
3.917_Homeless_Start_Date has 1073 (53.0%) missing values Missing
3.917_Length_of_Stay has 1066 (52.6%) missing values Missing
3.917_Living_Situation has 1066 (52.6%) missing values Missing
3.917_Stayed_Less_Than_90_Days has constant value "nan" Rejected
3.917_Times_Homeless_Last_3_Years has 1071 (52.9%) missing values Missing
3.917_Total_Months_Homeless_Last_3_Years has 1073 (53.0%) missing values Missing
3.917b_Stayed_in_Streets,_ES_or_SH_Night_Before has constant value "nan" Rejected
3.917b_Stayed_Less_Than_7_Nights has constant value "nan" Rejected
4.05_Physical_Disability has 1902 (93.9%) missing values Missing
4.06_Developmental_Disability has 1913 (94.5%) missing values Missing
4.07_Chronic_Health_Condition has 1863 (92.0%) missing values Missing
4.08_HIV/AIDS has 2023 (99.9%) missing values Missing
4.09_Mental_Health_Problem has 1765 (87.2%) missing values Missing
4.10_Alcohol_Abuse_(Substance_Abuse) has 1984 (98.0%) missing values Missing
4.10_Drug_Abuse_(Substance_Abuse) has 1962 (96.9%) missing values Missing
4.11_Domestic_Violence has 1418 (70.0%) missing values Missing
4.11_Domestic_Violence_-_Currently_Fleeing_DV? has 1934 (95.5%) missing values Missing
4.11_Domestic_Violence_-_When_it_Occurred has 1934 (95.5%) missing values Missing
4.12_Contact_Services has 800 (39.5%) zeros Zeros
4.13_Engagement_Date has 1564 (77.2%) missing values Missing
4.1_Housing_Status has 842 (41.6%) missing values Missing
4.24_Connected_to_McKinney_Vento_Liason_(Retired) has 1881 (92.9%) missing values Missing
4.24_Current_Status_(Retired_Data_Element) has 1716 (84.7%) missing values Missing
4.24_In_School_(Retired_Data_Element) has constant value "nan" Rejected
4.2_Income_Total_at_Entry has 1712 (84.5%) missing values Missing
4.2_Income_Total_at_Exit has 1688 (83.4%) missing values Missing
4.3_Non-Cash_Benefit_Count has 1592 (78.6%) zeros Zeros
4.3_Non-Cash_Benefit_Count_at_Exit has 1584 (78.2%) zeros Zeros
4.4_Covered_by_Health_Insurance has 119 (5.9%) missing values Missing
Age_at_Enrollment has 106 (5.2%) zeros Zeros
Barrier_Count_at_Entry has 1590 (78.5%) zeros Zeros
Bed_Nights_During_Report_Period has 195 (9.6%) zeros Zeros
Bed_Nights_During_Report_Period has 178 (8.8%) missing values Missing
CaseChildren has 113 (5.6%) zeros Zeros
CaseMembers is highly correlated with CaseChildren (ρ = 0.9420297129) Rejected
ClientID has constant value "1" Rejected
Coordinated_Entry_|_Most_Recent_Enrollment has a high cardinality: 406 distinct values Warning
Coordinated_Entry_|_Most_Recent_Enrollment has 334 (16.5%) missing values Missing
Count_of_Bed_Nights_(Housing_Check-ins) is highly correlated with Bed_Nights_During_Report_Period (ρ = 1) Rejected
Count_of_Bed_Nights_-_Entire_Episode is highly correlated with Count_of_Bed_Nights_(Housing_Check-ins) (ρ = 1) Rejected
Current_Age is highly correlated with Age_at_Enrollment (ρ = 0.9983527746) Rejected
CurrentDate has constant value "2019-12-04 21:12:14.183000" Rejected
Date_of_First_Contact_(Beta) has 800 (39.5%) missing values Missing
Date_of_First_ES_Stay_(Beta) has 362 (17.9%) missing values Missing
Date_of_Last_Contact_(Beta) has 800 (39.5%) missing values Missing
Date_of_Last_ES_Stay_(Beta) has 362 (17.9%) missing values Missing
Days_Enrolled_Until_RRH_Date_of_Move-in has constant value "No Move-In Date" Rejected
Emergency_Shelter_|_Most_Recent_Enrollment has a high cardinality: 607 distinct values Warning
HEN-HP_Referral_Most_Recent has constant value "nan" Rejected
HEN-RRH_Referral_Most_Recent has constant value "nan" Rejected
InfoReleaseNo has 27 (1.3%) missing values Missing
Latitude has 1933 (95.5%) missing values Missing
Length_of_Time_Homeless_(3.917_Approximate_Start) has 1073 (53.0%) missing values Missing
Longitude has 1933 (95.5%) missing values Missing
Municipality_(City_or_County) has 1950 (96.3%) missing values Missing
Prevention_|_Most_Recent_Enrollment has 1948 (96.2%) missing values Missing
ProgramType has constant value "1" Rejected
PSH_|_Most_Recent_Enrollment has 2001 (98.8%) missing values Missing
R10_Pregnancy_Due_Date has constant value "nan" Rejected
R10_Pregnancy_Status has constant value "nan" Rejected
R1_Referral_Source has constant value "nan" Rejected
R2_Date_Status_Determined has constant value "nan" Rejected
R2_Enroll_Status has constant value "nan" Rejected
R2_Reason_Why_No_Services_Funded has constant value "nan" Rejected
R2_Runaway_Youth has constant value "nan" Rejected
R3_Sexual_Orientation has constant value "nan" Rejected
R4_Last_Grade_Completed has 1752 (86.5%) missing values Missing
R5_School_Status has 1836 (90.7%) missing values Missing
R6_Employed_Status has 1645 (81.2%) missing values Missing
R6_Looking_for_Work has 2024 (> 99.9%) missing values Missing
R6_Type_of_Employment has 2006 (99.1%) missing values Missing
R6_Why_Not_Employed has 1663 (82.1%) missing values Missing
R7_General_Health_Status has constant value "nan" Rejected
R8_Dental_Health_Status has constant value "nan" Rejected
R9_Mental_Health_Status has constant value "nan" Rejected
RRH_Date_Of_Move-In has constant value "nan" Rejected
RRH_In_Permanent_Housing has constant value "nan" Rejected
RRH_|_Most_Recent_Enrollment has a high cardinality: 327 distinct values Warning
RRH_|_Most_Recent_Enrollment has 828 (40.9%) missing values Missing
SOAR_Eligibility_Determination_(Most_Recent) has 2014 (99.5%) missing values Missing
SOAR_Enrollment_Determination_(Most_Recent) has constant value "nan" Rejected
Street_Outreach_|_Most_Recent_Enrollment has 1967 (97.1%) missing values Missing
Transitional_Housing_|_Most_Recent_Enrollment has a high cardinality: 75 distinct values Warning
Transitional_Housing_|_Most_Recent_Enrollment has 1831 (90.4%) missing values Missing
V5_Last_Permanent_Address has 1374 (67.9%) missing values Missing
V5_Prior_Address has a high cardinality: 249 distinct values Warning
V5_Prior_Address has 1708 (84.3%) missing values Missing
V5_State has 1534 (75.8%) missing values Missing
V5_Zip has 1534 (75.8%) missing values Missing
WorkSource_Referral_Most_Recent has constant value "nan" Rejected
YAHP_Referral_Most_Recent has constant value "nan" Rejected

Variables

2.1_Organization_Name
Constant

This variable is constant and should be ignored for analysis

Constant valueFamily Promise of Spokane

2.2_Project_Name
Categorical

Distinct count2
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
FPS--ES--Open Doors
1847
FPS--ES--Bridges Family Shelter
 
178
ValueCountFrequency (%) 
FPS--ES--Open Doors 1847 91.2%
 
FPS--ES--Bridges Family Shelter 178 8.8%
 
Max length31
Mean length20.05481481
Min length19
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

2.4_ProjectType
Constant

This variable is constant and should be ignored for analysis

Constant valueEmergency shelter

2.5_Utilization_Tracking_Method_(Invalid)
Recoded

This variable is a recoding of 2.2_Project_Name and should be ignored for analysis

2.6_Federal_Grant_Programs
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

3.10_Enroll_Date
Date

Distinct count436
Unique (%)21.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Minimum2015-11-02 00:00:00
Maximum2019-11-29 00:00:00
Mini histogram
Histogram
Histogram of '3.10_Enroll_Date' (bins=N)

3.11_Exit_Date
Date

Distinct count401
Unique (%)19.8%
Missing (%)7.5%
Missing (n)152
Infinite (%)0.0%
Infinite (n)0
Minimum2016-02-13 00:00:00
Maximum2019-11-26 00:00:00
Mini histogram
Histogram
Histogram of '3.11_Exit_Date' (bins=N)

3.12_Exit_Destination
Categorical

Distinct count22
Unique (%)1.1%
Missing (%)7.5%
Missing (n)152
No exit interview completed
348
Client refused
301
Emergency shelter, including hotel or motel paid for with emergency shelter voucher, or RHY-funded Host Home shelter
274
Other values (18)
950
ValueCountFrequency (%) 
No exit interview completed 348 17.2%
 
Client refused 301 14.9%
 
Emergency shelter, including hotel or motel paid for with emergency shelter voucher, or RHY-funded Host Home shelter 274 13.5%
 
Rental by client with RRH or equivalent subsidy 225 11.1%
 
Rental by client, no ongoing housing subsidy 176 8.7%
 
Transitional Housing for homeless persons (including homeless youth) 127 6.3%
 
Rental by client, other ongoing housing subsidy 72 3.6%
 
Staying or living with family, permanent tenure 70 3.5%
 
Staying or living with family, temporary tenure (e.g., room, apartment or house) 69 3.4%
 
Data not collected 46 2.3%
 
Other values (11) 165 8.1%
 
(Missing) 152 7.5%
 
Max length125
Mean length48.48938272
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

3.15_Relationship_to_HoH
Categorical

Distinct count11
Unique (%)0.5%
Missing (%)0.0%
Missing (n)0
Self
607
Son
553
Daughter
479
Other values (8)
386
ValueCountFrequency (%) 
Self 607 30.0%
 
Son 553 27.3%
 
Daughter 479 23.7%
 
Significant Other (Non-Married) 183 9.0%
 
Spouse 140 6.9%
 
Other Family Member 26 1.3%
 
Grandchild 21 1.0%
 
Dependent Child 8 0.4%
 
Step Child 5 0.2%
 
Other Non-Family 2 0.1%
 
Max length31
Mean length7.579753086
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

3.16_Client_Location
Categorical

Distinct count3
Unique (%)0.1%
Missing (%)70.7%
Missing (n)1432
Spokane City & County CoC
592
florence/Northwest Alabama
 
1
(Missing)
1432
ValueCountFrequency (%) 
Spokane City & County CoC 592 29.2%
 
florence/Northwest Alabama 1 < 0.1%
 
(Missing) 1432 70.7%
 
Max length26
Mean length9.442962963
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

3.1_FirstName
Categorical

Distinct count1032
Unique (%)51.0%
Missing (%)0.0%
Missing (n)0
Anonymous
 
263
Michael
 
14
Jacob
 
14
Other values (1029)
1734
ValueCountFrequency (%) 
Anonymous 263 13.0%
 
Michael 14 0.7%
 
Jacob 14 0.7%
 
Matthew 13 0.6%
 
David 13 0.6%
 
Joshua 13 0.6%
 
Jessica 11 0.5%
 
Joseph 11 0.5%
 
James 10 0.5%
 
Michelle 10 0.5%
 
Other values (1022) 1653 81.6%
 
Max length19
Mean length6.555061728
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

3.1_LastName
Categorical

Distinct count847
Unique (%)41.8%
Missing (%)0.0%
Missing (n)0
Anonymous
 
130
Smith
 
21
White
 
20
Other values (844)
1854
ValueCountFrequency (%) 
Anonymous 130 6.4%
 
Smith 21 1.0%
 
White 20 1.0%
 
Johnson 19 0.9%
 
Jones 15 0.7%
 
Williams 14 0.7%
 
Savage 12 0.6%
 
Ellingburg 11 0.5%
 
Morris 11 0.5%
 
Chavez 11 0.5%
 
Other values (837) 1761 87.0%
 
Max length19
Mean length7.179753086
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

3.2_Social_Security_Quality
Categorical

Distinct count5
Unique (%)0.2%
Missing (%)0.0%
Missing (n)0
Full SSN
1063
Client Refused
476
Data not collected
254
Other values (2)
232
ValueCountFrequency (%) 
Full SSN 1063 52.5%
 
Client Refused 476 23.5%
 
Data not collected 254 12.5%
 
Approximate or partial SSN reported 127 6.3%
 
Client doesn't know 105 5.2%
 
Max length35
Mean length12.92839506
Min length8
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

3.2_SocSecNo
Categorical

Distinct count989
Unique (%)48.8%
Missing (%)41.2%
Missing (n)835
472-23-1378
 
4
539-35-7101
 
4
427-41-8671
 
4
Other values (985)
1178
(Missing)
835
ValueCountFrequency (%) 
472-23-1378 4 0.2%
 
539-35-7101 4 0.2%
 
427-41-8671 4 0.2%
 
462-81-0225 3 0.1%
 
691-89-0280 3 0.1%
 
534-31-6609 3 0.1%
 
574-82-8253 3 0.1%
 
574-59-6149 3 0.1%
 
754-07-1953 3 0.1%
 
612-11-3667 3 0.1%
 
Other values (978) 1157 57.1%
 
(Missing) 835 41.2%
 
Max length11
Mean length7.701234568
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

3.3_Birthdate
Date

Distinct count1456
Unique (%)71.9%
Missing (%)0.1%
Missing (n)3
Infinite (%)0.0%
Infinite (n)0
Minimum1953-06-02 00:00:00
Maximum2019-10-28 00:00:00
Mini histogram
Histogram
Histogram of '3.3_Birthdate' (bins=N)

3.3_Birthdate_Quality
Categorical

Distinct count4
Unique (%)0.2%
Missing (%)0.0%
Missing (n)0
Full DOB Reported
1771
Approximate or Partial DOB Reported
 
251
Data not collected
 
2
ValueCountFrequency (%) 
Full DOB Reported 1771 87.5%
 
Approximate or Partial DOB Reported 251 12.4%
 
Data not collected 2 0.1%
 
Client refused 1 < 0.1%
 
Max length35
Mean length19.23061728
Min length14
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

3.4_Race
Categorical

Distinct count10
Unique (%)0.5%
Missing (%)< 0.1%
Missing (n)1
White
1262
American Indian or Alaska Native
 
217
Black or African American
 
199
Other values (6)
346
ValueCountFrequency (%) 
White 1262 62.3%
 
American Indian or Alaska Native 217 10.7%
 
Black or African American 199 9.8%
 
Multi-Racial 174 8.6%
 
Native Hawaiian or Other Pacific Islander 128 6.3%
 
Client refused 30 1.5%
 
Data not collected 6 0.3%
 
Client doesn't know 5 0.2%
 
Asian 3 0.1%
 
(Missing) 1 < 0.1%
 
Max length41
Mean length12.94123457
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

3.5_Ethnicity
Categorical

Distinct count6
Unique (%)0.3%
Missing (%)< 0.1%
Missing (n)1
Non-Hispanic/Latino
1791
Hispanic/Latino
 
202
Client refused
 
22
Other values (2)
 
9
ValueCountFrequency (%) 
Non-Hispanic/Latino 1791 88.4%
 
Hispanic/Latino 202 10.0%
 
Client refused 22 1.1%
 
Data not collected 7 0.3%
 
Client doesn't know 2 0.1%
 
(Missing) 1 < 0.1%
 
Max length19
Mean length18.53530864
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

3.6_Gender
Categorical

Distinct count4
Unique (%)0.2%
Missing (%)0.0%
Missing (n)0
Female
1060
Male
962
Trans Male (FTM or Female to Male)
 
2
ValueCountFrequency (%) 
Female 1060 52.3%
 
Male 962 47.5%
 
Trans Male (FTM or Female to Male) 2 0.1%
 
Client refused 1 < 0.1%
 
Max length34
Mean length5.081481481
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

3.7_Veteran_Status
Categorical

Distinct count5
Unique (%)0.2%
Missing (%)49.0%
Missing (n)992
No
993
Yes
 
32
Client refused
 
6
(Missing)
992
ValueCountFrequency (%) 
No 993 49.0%
 
Yes 32 1.6%
 
Client refused 6 0.3%
 
Data Not Collected 2 0.1%
 
(Missing) 992 49.0%
 
Max length18
Mean length2.557037037
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

3.8_Disabling_Condition_at_Entry
Categorical

Distinct count6
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
No
1440
Yes
452
Missing
 
104
Other values (3)
 
29
ValueCountFrequency (%) 
No 1440 71.1%
 
Yes 452 22.3%
 
Missing 104 5.1%
 
Client refused 17 0.8%
 
Data not collected 11 0.5%
 
Client doesnt know 1 < 0.1%
 
Max length18
Mean length2.675555556
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

3.917_Homeless_Start_Date
Date

Distinct count419
Unique (%)20.7%
Missing (%)53.0%
Missing (n)1073
Infinite (%)0.0%
Infinite (n)0
Minimum2009-11-16 00:00:00
Maximum2019-11-27 00:00:00
Mini histogram
Histogram
Histogram of '3.917_Homeless_Start_Date' (bins=N)

3.917_Length_of_Stay
Categorical

Distinct count10
Unique (%)0.5%
Missing (%)52.6%
Missing (n)1066
Two to six nights
 
202
One week or more, but less than one month
 
193
One night or less
 
152
Other values (6)
412
(Missing)
1066
ValueCountFrequency (%) 
Two to six nights 202 10.0%
 
One week or more, but less than one month 193 9.5%
 
One night or less 152 7.5%
 
One month or more, but less than 90 days 138 6.8%
 
90 days or more, but less than one year 116 5.7%
 
Data not collected 71 3.5%
 
One year or longer 46 2.3%
 
Client refused 37 1.8%
 
Client doesn't know 4 0.2%
 
(Missing) 1066 52.6%
 
Max length41
Mean length14.75209877
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

3.917_Living_Situation
Categorical

Distinct count17
Unique (%)0.8%
Missing (%)52.6%
Missing (n)1066
Place not meant for habitation
359
Emergency shelter, including hotel or motel paid for with emergency shelter voucher, or RHY-funded Host Home shelter
 
157
Hotel or motel paid for without emergency shelter voucher
 
136
Other values (13)
307
(Missing)
1066
ValueCountFrequency (%) 
Place not meant for habitation 359 17.7%
 
Emergency shelter, including hotel or motel paid for with emergency shelter voucher, or RHY-funded Host Home shelter 157 7.8%
 
Hotel or motel paid for without emergency shelter voucher 136 6.7%
 
Staying or living in a friend's room, apartment or house 110 5.4%
 
Staying or living in a family member's room, apartment or house 91 4.5%
 
Rental by client, no ongoing housing subsidy 51 2.5%
 
Client refused 30 1.5%
 
Data not collected 10 0.5%
 
Hospital or other residential non-psychiatric medical facility 6 0.3%
 
Substance abuse treatment facility or detox center 2 0.1%
 
Other values (6) 7 0.3%
 
(Missing) 1066 52.6%
 
Max length116
Mean length27.3382716
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

3.917_Stayed_Less_Than_90_Days
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

3.917_Times_Homeless_Last_3_Years
Categorical

Distinct count8
Unique (%)0.4%
Missing (%)52.9%
Missing (n)1071
One time
415
Two times
 
184
Four or more times
 
121
Other values (4)
234
(Missing)
1071
ValueCountFrequency (%) 
One time 415 20.5%
 
Two times 184 9.1%
 
Four or more times 121 6.0%
 
Three times 98 4.8%
 
Data not collected 77 3.8%
 
Client refused 44 2.2%
 
Client doesn't know 15 0.7%
 
(Missing) 1071 52.9%
 
Max length19
Mean length6.781234568
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

3.917_Total_Months_Homeless_Last_3_Years
Categorical

Distinct count17
Unique (%)0.8%
Missing (%)53.0%
Missing (n)1073
One month (this time is the first month)
225
More than 12 months
224
Data not collected
 
89
Other values (13)
414
(Missing)
1073
ValueCountFrequency (%) 
One month (this time is the first month) 225 11.1%
 
More than 12 months 224 11.1%
 
Data not collected 89 4.4%
 
2 78 3.9%
 
6 54 2.7%
 
Client refused 53 2.6%
 
3 48 2.4%
 
4 46 2.3%
 
8 25 1.2%
 
12 21 1.0%
 
Other values (6) 89 4.4%
 
(Missing) 1073 53.0%
 
Max length40
Mean length9.591111111
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

3.917b_Stayed_in_Streets,_ES_or_SH_Night_Before
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

3.917b_Stayed_Less_Than_7_Nights
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

4.05_Physical_Disability
Categorical

Distinct count2
Unique (%)0.1%
Missing (%)93.9%
Missing (n)1902
Physical Disability
 
123
(Missing)
1902
ValueCountFrequency (%) 
Physical Disability 123 6.1%
 
(Missing) 1902 93.9%
 
Max length19
Mean length3.971851852
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

4.06_Developmental_Disability
Categorical

Distinct count2
Unique (%)0.1%
Missing (%)94.5%
Missing (n)1913
Developmental Disability
 
112
(Missing)
1913
ValueCountFrequency (%) 
Developmental Disability 112 5.5%
 
(Missing) 1913 94.5%
 
Max length24
Mean length4.161481481
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

4.07_Chronic_Health_Condition
Categorical

Distinct count2
Unique (%)0.1%
Missing (%)92.0%
Missing (n)1863
Chronic Health
 
162
(Missing)
1863
ValueCountFrequency (%) 
Chronic Health 162 8.0%
 
(Missing) 1863 92.0%
 
Max length14
Mean length3.88
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

4.08_HIV/AIDS
Categorical

Distinct count2
Unique (%)0.1%
Missing (%)99.9%
Missing (n)2023
HIV/AIDS
 
2
(Missing)
2023
ValueCountFrequency (%) 
HIV/AIDS 2 0.1%
 
(Missing) 2023 99.9%
 
Max length8
Mean length3.004938272
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsTrue

4.09_Mental_Health_Problem
Categorical

Distinct count2
Unique (%)0.1%
Missing (%)87.2%
Missing (n)1765
Mental Illness
 
260
(Missing)
1765
ValueCountFrequency (%) 
Mental Illness 260 12.8%
 
(Missing) 1765 87.2%
 
Max length14
Mean length4.412345679
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

4.10_Alcohol_Abuse_(Substance_Abuse)
Categorical

Distinct count2
Unique (%)0.1%
Missing (%)98.0%
Missing (n)1984
Alcohol Abuse
 
41
(Missing)
1984
ValueCountFrequency (%) 
Alcohol Abuse 41 2.0%
 
(Missing) 1984 98.0%
 
Max length13
Mean length3.202469136
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

4.10_Drug_Abuse_(Substance_Abuse)
Categorical

Distinct count2
Unique (%)0.1%
Missing (%)96.9%
Missing (n)1962
Drug Abuse
 
63
(Missing)
1962
ValueCountFrequency (%) 
Drug Abuse 63 3.1%
 
(Missing) 1962 96.9%
 
Max length10
Mean length3.217777778
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

4.11_Domestic_Violence
Categorical

Distinct count4
Unique (%)0.2%
Missing (%)70.0%
Missing (n)1418
No
486
Yes
 
91
Refused
 
30
(Missing)
1418
ValueCountFrequency (%) 
No 486 24.0%
 
Yes 91 4.5%
 
Refused 30 1.5%
 
(Missing) 1418 70.0%
 
Max length7
Mean length2.819259259
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

4.11_Domestic_Violence_-_Currently_Fleeing_DV?
Boolean

Distinct count3
Unique (%)0.1%
Missing (%)95.5%
Missing (n)1934
Yes
 
74
No
 
17
(Missing)
1934
ValueCountFrequency (%) 
Yes 74 3.7%
 
No 17 0.8%
 
(Missing) 1934 95.5%
 

4.11_Domestic_Violence_-_When_it_Occurred
Categorical

Distinct count7
Unique (%)0.3%
Missing (%)95.5%
Missing (n)1934
Within the past three months
 
38
Data not collected
 
23
Client refused
 
14
Other values (3)
 
16
(Missing)
1934
ValueCountFrequency (%) 
Within the past three months 38 1.9%
 
Data not collected 23 1.1%
 
Client refused 14 0.7%
 
One year ago or more 10 0.5%
 
Three to six months ago (excluding six months exactly) 3 0.1%
 
Six months to one year ago (excluding one year exactly) 3 0.1%
 
(Missing) 1934 95.5%
 
Max length55
Mean length3.952098765
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

4.12_Contact_Services
Numeric

Distinct count51
Unique (%)2.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean2.56691358
Minimum0
Maximum114
Zeros (%)39.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q31
95-th percentile14
Maximum114
Range114
Interquartile range1

Descriptive statistics

Standard deviation7.289916123
Coef of variation2.839953857
Kurtosis65.43905812
Mean2.56691358
MAD3.332435909
Skewness6.689383407
Sum5198
Variance53.14287708
Memory size15.9 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 4.5 9.5 19.5 28.5 46. 114. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 800 39.5%
 
1 799 39.5%
 
2 121 6.0%
 
3 49 2.4%
 
4 33 1.6%
 
5 25 1.2%
 
7 19 0.9%
 
8 16 0.8%
 
9 12 0.6%
 
6 11 0.5%
 
Other values (41) 140 6.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 800 39.5%
 
1 799 39.5%
 
2 121 6.0%
 
3 49 2.4%
 
4 33 1.6%
 

Maximum 5 values

ValueCountFrequency (%) 
114 1 < 0.1%
 
103 1 < 0.1%
 
77 1 < 0.1%
 
69 1 < 0.1%
 
66 1 < 0.1%
 

4.13_Engagement_Date
Date

Distinct count204
Unique (%)10.1%
Missing (%)77.2%
Missing (n)1564
Infinite (%)0.0%
Infinite (n)0
Minimum2017-09-15 00:00:00
Maximum2019-12-18 00:00:00
Mini histogram
Histogram
Histogram of '4.13_Engagement_Date' (bins=N)

4.1_Housing_Status
Categorical

Distinct count7
Unique (%)0.3%
Missing (%)41.6%
Missing (n)842
Category 1 - Homeless
1135
Category 4 - Fleeing domestic violence
 
21
Category 2 - At imminent risk of losing housing
 
18
Other values (3)
 
9
(Missing)
842
ValueCountFrequency (%) 
Category 1 - Homeless 1135 56.0%
 
Category 4 - Fleeing domestic violence 21 1.0%
 
Category 2 - At imminent risk of losing housing 18 0.9%
 
At-risk of homelessness 5 0.2%
 
Client refused 2 0.1%
 
Category 3 - Homeless only under other federal statutes 2 0.1%
 
(Missing) 842 41.6%
 
Max length55
Mean length13.9545679
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

4.24_Connected_to_McKinney_Vento_Liason_(Retired)
Categorical

Distinct count6
Unique (%)0.3%
Missing (%)92.9%
Missing (n)1881
No
 
60
Yes
 
35
Data Not Collected
 
18
Other values (2)
 
31
(Missing)
1881
ValueCountFrequency (%) 
No 60 3.0%
 
Yes 35 1.7%
 
Data Not Collected 18 0.9%
 
Client refused 16 0.8%
 
Client doesn't know 15 0.7%
 
(Missing) 1881 92.9%
 
Max length19
Mean length3.309135802
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

4.24_Current_Status_(Retired_Data_Element)
Categorical

Distinct count4
Unique (%)0.2%
Missing (%)84.7%
Missing (n)1716
Yes
 
166
No
 
90
Refused
 
53
(Missing)
1716
ValueCountFrequency (%) 
Yes 166 8.2%
 
No 90 4.4%
 
Refused 53 2.6%
 
(Missing) 1716 84.7%
 
Max length7
Mean length3.060246914
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

4.24_In_School_(Retired_Data_Element)
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

4.2_Income_Total_at_Entry
Numeric

Distinct count168
Unique (%)8.3%
Missing (%)84.5%
Missing (n)1712
Infinite (%)0.0%
Infinite (n)0
Mean883.4784345
Minimum0
Maximum4500
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile204.2
Q1459
Median750
Q31118
95-th percentile2022
Maximum4500
Range4500
Interquartile range659

Descriptive statistics

Standard deviation626.693811
Coef of variation0.7093481703
Kurtosis6.657090597
Mean883.4784345
MAD452.7835085
Skewness2.043802072
Sum276528.75
Variance392745.1327
Memory size15.9 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
750 16 0.8%
 
569 11 0.5%
 
670 11 0.5%
 
459 11 0.5%
 
1600 9 0.4%
 
420 9 0.4%
 
197 8 0.4%
 
771 7 0.3%
 
500 5 0.2%
 
363 5 0.2%
 
Other values (157) 221 10.9%
 
(Missing) 1712 84.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 < 0.1%
 
11.5 1 < 0.1%
 
18.57 1 < 0.1%
 
61 1 < 0.1%
 
100 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
4500 1 < 0.1%
 
4380 1 < 0.1%
 
3038.76 1 < 0.1%
 
3000 1 < 0.1%
 
2790 1 < 0.1%
 

4.2_Income_Total_at_Exit
Numeric

Distinct count189
Unique (%)9.3%
Missing (%)83.4%
Missing (n)1688
Infinite (%)0.0%
Infinite (n)0
Mean922.8316914
Minimum0
Maximum4500
Zeros (%)0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile197
Q1465
Median750
Q31200
95-th percentile2164.624
Maximum4500
Range4500
Interquartile range735

Descriptive statistics

Standard deviation648.7061192
Coef of variation0.702951714
Kurtosis3.643186571
Mean922.8316914
MAD487.0553442
Skewness1.642032722
Sum310994.28
Variance420819.6291
Memory size15.9 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
569 16 0.8%
 
459 15 0.7%
 
750 13 0.6%
 
670 12 0.6%
 
420 10 0.5%
 
197 8 0.4%
 
521 7 0.3%
 
1600 5 0.2%
 
1000 5 0.2%
 
2000 5 0.2%
 
Other values (178) 241 11.9%
 
(Missing) 1688 83.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 2 0.1%
 
9.47 1 < 0.1%
 
18.57 1 < 0.1%
 
58 1 < 0.1%
 
61 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
4500 1 < 0.1%
 
3200 1 < 0.1%
 
3040 1 < 0.1%
 
3038.76 1 < 0.1%
 
3000 2 0.1%
 

4.3_Non-Cash_Benefit_Count
Numeric

Distinct count7
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.2409876543
Minimum0
Maximum10
Zeros (%)78.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum10
Range10
Interquartile range0

Descriptive statistics

Standard deviation0.5400913152
Coef of variation2.241157609
Kurtosis60.15719995
Mean0.2409876543
MAD0.378915897
Skewness4.943663863
Sum488
Variance0.2916986288
Memory size15.9 KiB
Histogram
Histogram with fixed size bins (bins=7)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 10. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 1592 78.6%
 
1 398 19.7%
 
2 28 1.4%
 
4 4 0.2%
 
10 1 < 0.1%
 
5 1 < 0.1%
 
3 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1592 78.6%
 
1 398 19.7%
 
2 28 1.4%
 
3 1 < 0.1%
 
4 4 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
10 1 < 0.1%
 
5 1 < 0.1%
 
4 4 0.2%
 
3 1 < 0.1%
 
2 28 1.4%
 

4.3_Non-Cash_Benefit_Count_at_Exit
Numeric

Distinct count5
Unique (%)0.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.252345679
Minimum0
Maximum4
Zeros (%)78.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum4
Range4
Interquartile range0

Descriptive statistics

Standard deviation0.5175054935
Coef of variation2.050780087
Kurtosis5.395669465
Mean0.252345679
MAD0.3947807956
Skewness2.191381968
Sum511
Variance0.2678119358
Memory size15.9 KiB
Histogram
Histogram with fixed size bins (bins=5)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 4. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 1584 78.2%
 
1 380 18.8%
 
2 53 2.6%
 
3 7 0.3%
 
4 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1584 78.2%
 
1 380 18.8%
 
2 53 2.6%
 
3 7 0.3%
 
4 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
4 1 < 0.1%
 
3 7 0.3%
 
2 53 2.6%
 
1 380 18.8%
 
0 1584 78.2%
 

4.4_Covered_by_Health_Insurance
Categorical

Distinct count6
Unique (%)0.3%
Missing (%)5.9%
Missing (n)119
Yes
1576
No
 
170
Data Not Collected
 
121
Other values (2)
 
39
(Missing)
 
119
ValueCountFrequency (%) 
Yes 1576 77.8%
 
No 170 8.4%
 
Data Not Collected 121 6.0%
 
Client refused 38 1.9%
 
Client doesn't know 1 < 0.1%
 
(Missing) 119 5.9%
 
Max length19
Mean length4.026666667
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

5.8_Personal_ID
Numeric

Distinct count1710
Unique (%)84.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean74479.87951
Minimum11506
Maximum97819
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum11506
5-th percentile36476.4
Q166823
Median79192
Q387192
95-th percentile95893.8
Maximum97819
Range86313
Interquartile range20369

Descriptive statistics

Standard deviation18269.22339
Coef of variation0.2452907217
Kurtosis0.9907843956
Mean74479.87951
MAD14097.67789
Skewness-1.226315712
Sum150821756
Variance333764523.4
Memory size15.9 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[11506. 11509.5 19842.5 19935.5 29823.5 ... 96862.5 97399.5 97409.5 97815.5 97819. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
80933 5 0.2%
 
46423 4 0.2%
 
80932 4 0.2%
 
46422 4 0.2%
 
77164 4 0.2%
 
53945 4 0.2%
 
21284 4 0.2%
 
76780 3 0.1%
 
80826 3 0.1%
 
60754 3 0.1%
 
Other values (1700) 1987 98.1%
 

Minimum 5 values

ValueCountFrequency (%) 
11506 1 < 0.1%
 
11508 1 < 0.1%
 
11509 1 < 0.1%
 
11510 1 < 0.1%
 
12041 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
97819 1 < 0.1%
 
97818 1 < 0.1%
 
97817 1 < 0.1%
 
97816 1 < 0.1%
 
97815 1 < 0.1%
 

5.9_Household_ID
Numeric

Distinct count615
Unique (%)30.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean103375.1378
Minimum66046
Maximum124920
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum66046
5-th percentile88009
Q193183
Median104752
Q3112507
95-th percentile122328
Maximum124920
Range58874
Interquartile range19324

Descriptive statistics

Standard deviation11958.34062
Coef of variation0.115679078
Kurtosis-0.4749897324
Mean103375.1378
MAD9960.431829
Skewness-0.1998042822
Sum209334654
Variance143001910.4
Memory size15.9 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 66046. 86800.5 88004.5 88013.5 88035.5 ... 123343.5 124544.5 124561.5 124915.5 124920. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
88041 12 0.6%
 
108079 10 0.5%
 
102361 9 0.4%
 
92785 9 0.4%
 
106345 8 0.4%
 
103263 8 0.4%
 
92947 7 0.3%
 
74587 7 0.3%
 
117576 7 0.3%
 
91790 7 0.3%
 
Other values (605) 1941 95.9%
 

Minimum 5 values

ValueCountFrequency (%) 
66046 4 0.2%
 
66563 3 0.1%
 
69908 3 0.1%
 
69909 2 0.1%
 
71335 2 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
124920 3 0.1%
 
124919 2 0.1%
 
124918 1 < 0.1%
 
124917 4 0.2%
 
124916 2 0.1%
 

Age_at_Enrollment
Numeric

Distinct count68
Unique (%)3.4%
Missing (%)0.1%
Missing (n)3
Infinite (%)0.0%
Infinite (n)0
Mean19.5553907
Minimum-1
Maximum66
Zeros (%)5.2%
Mini histogram

Quantile statistics

Minimum-1
5-th percentile0
Q16
Median16
Q332
95-th percentile46
Maximum66
Range67
Interquartile range26

Descriptive statistics

Standard deviation15.4689086
Coef of variation0.7910304035
Kurtosis-0.8472234587
Mean19.5553907
MAD13.6542924
Skewness0.4870898617
Sum39541
Variance239.2871332
Memory size15.9 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 106 5.2%
 
1 83 4.1%
 
5 81 4.0%
 
3 79 3.9%
 
7 78 3.9%
 
4 77 3.8%
 
2 75 3.7%
 
6 63 3.1%
 
9 60 3.0%
 
8 60 3.0%
 
Other values (57) 1260 62.2%
 

Minimum 5 values

ValueCountFrequency (%) 
-1 3 0.1%
 
0 106 5.2%
 
1 83 4.1%
 
2 75 3.7%
 
3 79 3.9%
 

Maximum 5 values

ValueCountFrequency (%) 
66 1 < 0.1%
 
65 2 0.1%
 
64 1 < 0.1%
 
62 1 < 0.1%
 
61 2 0.1%
 

Barrier_Count_at_Entry
Numeric

Distinct count7
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.3767901235
Minimum0
Maximum6
Zeros (%)78.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile2
Maximum6
Range6
Interquartile range0

Descriptive statistics

Standard deviation0.8445094513
Coef of variation2.24132587
Kurtosis7.646848627
Mean0.3767901235
MAD0.5917000457
Skewness2.636587551
Sum763
Variance0.7131962133
Memory size15.9 KiB
Histogram
Histogram with fixed size bins (bins=7)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 4.5 6. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 1590 78.5%
 
1 219 10.8%
 
2 137 6.8%
 
3 54 2.7%
 
4 20 1.0%
 
6 3 0.1%
 
5 2 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1590 78.5%
 
1 219 10.8%
 
2 137 6.8%
 
3 54 2.7%
 
4 20 1.0%
 

Maximum 5 values

ValueCountFrequency (%) 
6 3 0.1%
 
5 2 0.1%
 
4 20 1.0%
 
3 54 2.7%
 
2 137 6.8%
 

Bed_Nights_During_Report_Period
Numeric

Distinct count138
Unique (%)6.8%
Missing (%)8.8%
Missing (n)178
Infinite (%)0.0%
Infinite (n)0
Mean24.92636708
Minimum0
Maximum210
Zeros (%)9.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q12
Median9
Q334
95-th percentile100
Maximum210
Range210
Interquartile range32

Descriptive statistics

Standard deviation36.0986819
Coef of variation1.448212721
Kurtosis5.706420712
Mean24.92636708
MAD25.69997617
Skewness2.282620084
Sum46039
Variance1303.114835
Memory size15.9 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1 237 11.7%
 
0 195 9.6%
 
2 149 7.4%
 
4 87 4.3%
 
3 59 2.9%
 
5 57 2.8%
 
6 50 2.5%
 
11 46 2.3%
 
8 43 2.1%
 
7 40 2.0%
 
Other values (127) 884 43.7%
 
(Missing) 178 8.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 195 9.6%
 
1 237 11.7%
 
2 149 7.4%
 
3 59 2.9%
 
4 87 4.3%
 

Maximum 5 values

ValueCountFrequency (%) 
210 2 0.1%
 
208 1 < 0.1%
 
197 1 < 0.1%
 
196 1 < 0.1%
 
185 3 0.1%
 

CaseAdults
Numeric

Distinct count5
Unique (%)0.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.684444444
Minimum0
Maximum4
Zeros (%)0.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1
Q11
Median2
Q32
95-th percentile2
Maximum4
Range4
Interquartile range1

Descriptive statistics

Standard deviation0.552285943
Coef of variation0.3278742406
Kurtosis0.2792016766
Mean1.684444444
MAD0.4840076818
Skewness-0.09669720718
Sum3411
Variance0.3050197628
Memory size15.9 KiB
Histogram
Histogram with fixed size bins (bins=5)
ValueCountFrequency (%) 
2 1263 62.4%
 
1 684 33.8%
 
3 59 2.9%
 
0 13 0.6%
 
4 6 0.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 13 0.6%
 
1 684 33.8%
 
2 1263 62.4%
 
3 59 2.9%
 
4 6 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
4 6 0.3%
 
3 59 2.9%
 
2 1263 62.4%
 
1 684 33.8%
 
0 13 0.6%
 

CaseChildren
Numeric

Distinct count10
Unique (%)0.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean2.19654321
Minimum0
Maximum10
Zeros (%)5.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q11
Median2
Q33
95-th percentile5
Maximum10
Range10
Interquartile range2

Descriptive statistics

Standard deviation1.516994604
Coef of variation0.6906281641
Kurtosis4.630729629
Mean2.19654321
MAD1.121950434
Skewness1.620982969
Sum4448
Variance2.30127263
Memory size15.9 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 2.5 3.5 4.5 5.5 6.5 7.5 10. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 647 32.0%
 
2 578 28.5%
 
3 376 18.6%
 
4 188 9.3%
 
0 113 5.6%
 
5 67 3.3%
 
7 26 1.3%
 
10 12 0.6%
 
8 10 0.5%
 
6 8 0.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 113 5.6%
 
1 647 32.0%
 
2 578 28.5%
 
3 376 18.6%
 
4 188 9.3%
 

Maximum 5 values

ValueCountFrequency (%) 
10 12 0.6%
 
8 10 0.5%
 
7 26 1.3%
 
6 8 0.4%
 
5 67 3.3%
 

CaseMembers
Highly correlated

This variable is highly correlated with CaseChildren and should be ignored for analysis

Correlation0.9420297129

Chronic_Homeless_Status
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
0
1968
1
 
57
ValueCountFrequency (%) 
0 1968 97.2%
 
1 57 2.8%
 

Client_Record_Restricted
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
True
1406
False
619
ValueCountFrequency (%) 
True 1406 69.4%
 
False 619 30.6%
 

ClientID
Constant

This variable is constant and should be ignored for analysis

Constant value1

Coordinated_Entry_|_Most_Recent_Enrollment
Categorical

Distinct count406
Unique (%)20.0%
Missing (%)16.5%
Missing (n)334
08/26/2019 - Current: CC--CA-HFCA
 
21
03/27/2019 - Current: CC--CA-HFCA
 
20
10/24/2019 - Current: CC--CA-HFCA
 
20
Other values (402)
1630
(Missing)
334
ValueCountFrequency (%) 
08/26/2019 - Current: CC--CA-HFCA 21 1.0%
 
03/27/2019 - Current: CC--CA-HFCA 20 1.0%
 
10/24/2019 - Current: CC--CA-HFCA 20 1.0%
 
09/06/2018 - 12/31/2018: CC--CA-HFCA 20 1.0%
 
11/12/2019 - Current: CC--CA-HFCA 17 0.8%
 
09/19/2019 - Current: CC--CA-HFCA 17 0.8%
 
10/07/2019 - Current: CC--CA-HFCA 16 0.8%
 
09/25/2019 - Current: CC--CA-HFCA 15 0.7%
 
11/18/2019 - Current: CC--CA-HFCA 14 0.7%
 
11/04/2019 - Current: CC--CA-HFCA 14 0.7%
 
Other values (395) 1517 74.9%
 
(Missing) 334 16.5%
 
Max length39
Mean length30.0345679
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Count_of_Bed_Nights_(Housing_Check-ins)
Highly correlated

This variable is highly correlated with Bed_Nights_During_Report_Period and should be ignored for analysis

Correlation1

Count_of_Bed_Nights_-_Entire_Episode
Highly correlated

This variable is highly correlated with Count_of_Bed_Nights_(Housing_Check-ins) and should be ignored for analysis

Correlation1

Current_Age
Highly correlated

This variable is highly correlated with Age_at_Enrollment and should be ignored for analysis

Correlation0.9983527746

CurrentDate
Constant

This variable is constant and should be ignored for analysis

Constant value2019-12-04 21:12:14.183000

Date_of_First_Contact_(Beta)
Date

Distinct count276
Unique (%)13.6%
Missing (%)39.5%
Missing (n)800
Infinite (%)0.0%
Infinite (n)0
Minimum2017-10-02 00:00:00
Maximum2019-09-24 00:00:00
Mini histogram
Histogram
Histogram of 'Date_of_First_Contact_(Beta)' (bins=N)

Date_of_First_ES_Stay_(Beta)
Date

Distinct count394
Unique (%)19.5%
Missing (%)17.9%
Missing (n)362
Infinite (%)0.0%
Infinite (n)0
Minimum2015-11-03 00:00:00
Maximum2019-11-29 00:00:00
Mini histogram
Histogram
Histogram of 'Date_of_First_ES_Stay_(Beta)' (bins=N)

Date_of_Last_Contact_(Beta)
Date

Distinct count345
Unique (%)17.0%
Missing (%)39.5%
Missing (n)800
Infinite (%)0.0%
Infinite (n)0
Minimum2017-10-02 00:00:00
Maximum2019-10-04 00:00:00
Mini histogram
Histogram
Histogram of 'Date_of_Last_Contact_(Beta)' (bins=N)

Date_of_Last_ES_Stay_(Beta)
Date

Distinct count392
Unique (%)19.4%
Missing (%)17.9%
Missing (n)362
Infinite (%)0.0%
Infinite (n)0
Minimum2015-11-03 00:00:00
Maximum2019-12-03 00:00:00
Mini histogram
Histogram
Histogram of 'Date_of_Last_ES_Stay_(Beta)' (bins=N)

Days_Enrolled_in_Project
Numeric

Distinct count154
Unique (%)7.6%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean44.79901235
Minimum0
Maximum309
Zeros (%)0.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1
Q110
Median30
Q363
95-th percentile142
Maximum309
Range309
Interquartile range53

Descriptive statistics

Standard deviation46.25321908
Coef of variation1.032460687
Kurtosis3.813538728
Mean44.79901235
MAD34.77561884
Skewness1.74384551
Sum90718
Variance2139.360276
Memory size15.9 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 3.5 5.5 ... 104.5 131. 197. 223. 309. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 143 7.1%
 
2 76 3.8%
 
3 62 3.1%
 
5 54 2.7%
 
32 49 2.4%
 
29 49 2.4%
 
22 44 2.2%
 
9 39 1.9%
 
12 39 1.9%
 
28 35 1.7%
 
Other values (144) 1435 70.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 10 0.5%
 
1 143 7.1%
 
2 76 3.8%
 
3 62 3.1%
 
4 33 1.6%
 

Maximum 5 values

ValueCountFrequency (%) 
309 4 0.2%
 
270 1 < 0.1%
 
243 1 < 0.1%
 
230 2 0.1%
 
216 6 0.3%
 

Days_Enrolled_Until_Engagement_Date
Categorical

Distinct count35
Unique (%)1.7%
Missing (%)0.0%
Missing (n)0
No Engagement Date
1564
1
 
77
0
 
73
Other values (32)
 
311
ValueCountFrequency (%) 
No Engagement Date 1564 77.2%
 
1 77 3.8%
 
0 73 3.6%
 
2 60 3.0%
 
3 43 2.1%
 
7 42 2.1%
 
4 38 1.9%
 
6 29 1.4%
 
5 28 1.4%
 
8 11 0.5%
 
Other values (25) 60 3.0%
 
Max length18
Mean length14.15802469
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Days_Enrolled_Until_RRH_Date_of_Move-in
Constant

This variable is constant and should be ignored for analysis

Constant valueNo Move-In Date

Emergency_Shelter_|_Most_Recent_Enrollment
Categorical

Distinct count607
Unique (%)30.0%
Missing (%)0.0%
Missing (n)0
05/06/2018 - 05/26/2018: FPS--ES--Open Doors
 
14
03/19/2019 - 06/23/2019: FPS--ES--Open Doors
 
14
11/27/2018 - 03/07/2019: CC--ES--SMS Shelter
 
12
Other values (604)
1985
ValueCountFrequency (%) 
05/06/2018 - 05/26/2018: FPS--ES--Open Doors 14 0.7%
 
03/19/2019 - 06/23/2019: FPS--ES--Open Doors 14 0.7%
 
11/27/2018 - 03/07/2019: CC--ES--SMS Shelter 12 0.6%
 
10/15/2017 - 01/14/2018: FPS--ES--Bridges Family Shelter 12 0.6%
 
05/31/2019 - Current: FPS--ES--Open Doors 12 0.6%
 
09/09/2018 - 11/05/2018: FPS--ES--Open Doors 12 0.6%
 
11/27/2019 - Current: FPS--ES--Open Doors 11 0.5%
 
06/05/2017 - 07/04/2017: FPS--ES--Open Doors 11 0.5%
 
06/05/2017 - 07/01/2017: FPS--ES--Open Doors 11 0.5%
 
07/01/2019 - Current: FPS--ES--Bridges Family Shelter 11 0.5%
 
Other values (597) 1905 94.1%
 
Max length65
Mean length45.34567901
Min length41
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Enrollment_Created_By
Categorical

Distinct count11
Unique (%)0.5%
Missing (%)0.0%
Missing (n)0
Serena Graves
758
Grant Wylie
453
Cyndi Cater
416
Other values (8)
398
ValueCountFrequency (%) 
Serena Graves 758 37.4%
 
Grant Wylie 453 22.4%
 
Cyndi Cater 416 20.5%
 
Lynnetta Lewis 123 6.1%
 
Kermit Nelson 103 5.1%
 
Bill Sharon 84 4.1%
 
Jennifer Snow 22 1.1%
 
Amy Robinson 21 1.0%
 
Susan Heitstuman 17 0.8%
 
Renee Norris 17 0.8%
 
Max length16
Mean length12.13135802
Min length11
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

HEN-HP_Referral_Most_Recent
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

HEN-RRH_Referral_Most_Recent
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

Household_Type
Categorical

Distinct count3
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Household with Adults and Children
1908
Household without Children
 
113
Household with Only Children
 
4
ValueCountFrequency (%) 
Household with Adults and Children 1908 94.2%
 
Household without Children 113 5.6%
 
Household with Only Children 4 0.2%
 
Max length34
Mean length33.5417284
Min length26
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

InfoReleaseNo
Categorical

Distinct count4
Unique (%)0.2%
Missing (%)1.3%
Missing (n)27
500
1987
142
 
9
10001
 
2
(Missing)
 
27
ValueCountFrequency (%) 
500 1987 98.1%
 
142 9 0.4%
 
10001 2 0.1%
 
(Missing) 27 1.3%
 
Max length7
Mean length4.975308642
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

Information_Release_Status
Categorical

Distinct count2
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Client may be seen by others
1987
Client NOT seen by others
 
38
ValueCountFrequency (%) 
Client may be seen by others 1987 98.1%
 
Client NOT seen by others 38 1.9%
 
Max length28
Mean length27.9437037
Min length25
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

Latitude
Numeric

Distinct count66
Unique (%)3.3%
Missing (%)95.5%
Missing (n)1933
Infinite (%)0.0%
Infinite (n)0
Mean47.68054801
Minimum47.62713091
Maximum47.97614504
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum47.62713091
5-th percentile47.63454062
Q147.6582179
Median47.67057119
Q347.68628489
95-th percentile47.74951002
Maximum47.97614504
Range0.3490141336
Interquartile range0.02806699289

Descriptive statistics

Standard deviation0.05060241851
Coef of variation0.001061280137
Kurtosis20.71880512
Mean47.68054801
MAD0.02770820981
Skewness4.048280356
Sum4386.610417
Variance0.002560604759
Memory size15.9 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
47.67494464 4 0.2%
 
47.68628489 4 0.2%
 
47.71132792 4 0.2%
 
47.6806544 3 0.1%
 
47.65993328 3 0.1%
 
47.66529561 2 0.1%
 
47.66350406 2 0.1%
 
47.668068 2 0.1%
 
47.71940107 2 0.1%
 
47.6977018 2 0.1%
 
Other values (55) 64 3.2%
 
(Missing) 1933 95.5%
 

Minimum 5 values

ValueCountFrequency (%) 
47.62713091 1 < 0.1%
 
47.62824536 1 < 0.1%
 
47.62871508 1 < 0.1%
 
47.62937961 1 < 0.1%
 
47.63333461 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
47.97614504 1 < 0.1%
 
47.95238061 1 < 0.1%
 
47.76980614 1 < 0.1%
 
47.75697818 1 < 0.1%
 
47.74961645 1 < 0.1%
 

Length_of_Time_Homeless_(3.917_Approximate_Start)
Numeric

Distinct count299
Unique (%)14.8%
Missing (%)53.0%
Missing (n)1073
Infinite (%)0.0%
Infinite (n)0
Mean186.1848739
Minimum-201
Maximum3624
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum-201
5-th percentile6
Q133
Median81
Q3180
95-th percentile755.4
Maximum3624
Range3825
Interquartile range147

Descriptive statistics

Standard deviation357.0481967
Coef of variation1.917707863
Kurtosis31.27239494
Mean186.1848739
MAD183.3323918
Skewness4.912828053
Sum177248
Variance127483.4148
Memory size15.9 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
2 15 0.7%
 
30 14 0.7%
 
33 13 0.6%
 
9 13 0.6%
 
8 13 0.6%
 
11 12 0.6%
 
81 12 0.6%
 
31 11 0.5%
 
46 11 0.5%
 
3 11 0.5%
 
Other values (288) 827 40.8%
 
(Missing) 1073 53.0%
 

Minimum 5 values

ValueCountFrequency (%) 
-201 1 < 0.1%
 
-180 1 < 0.1%
 
-131 1 < 0.1%
 
-28 1 < 0.1%
 
0 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
3624 1 < 0.1%
 
3514 1 < 0.1%
 
2935 1 < 0.1%
 
2834 1 < 0.1%
 
2535 1 < 0.1%
 

Longitude
Numeric

Distinct count66
Unique (%)3.3%
Missing (%)95.5%
Missing (n)1933
Infinite (%)0.0%
Infinite (n)0
Mean-117.3955647
Minimum-117.5877215
Maximum-117.2291847
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum-117.5877215
5-th percentile-117.4701472
Q1-117.4317502
Median-117.398158
Q3-117.3760512
95-th percentile-117.2582243
Maximum-117.2291847
Range0.3585367971
Interquartile range0.0556989381

Descriptive statistics

Standard deviation0.0636139152
Coef of variation-0.0005418766488
Kurtosis2.16196355
Mean-117.3955647
MAD0.04276271422
Skewness0.3318121431
Sum-10800.39195
Variance0.004046730207
Memory size15.9 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
-117.3760512 4 0.2%
 
-117.4077972 4 0.2%
 
-117.3812457 4 0.2%
 
-117.398158 3 0.1%
 
-117.2775347 3 0.1%
 
-117.4329945 2 0.1%
 
-117.4160664 2 0.1%
 
-117.3945534 2 0.1%
 
-117.4310077 2 0.1%
 
-117.368114 2 0.1%
 
Other values (55) 64 3.2%
 
(Missing) 1933 95.5%
 

Minimum 5 values

ValueCountFrequency (%) 
-117.5877215 1 < 0.1%
 
-117.5630163 2 0.1%
 
-117.4993772 1 < 0.1%
 
-117.4750783 1 < 0.1%
 
-117.4661127 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
-117.2291847 1 < 0.1%
 
-117.2326355 1 < 0.1%
 
-117.2338596 1 < 0.1%
 
-117.2371495 1 < 0.1%
 
-117.251794 1 < 0.1%
 

Municipality_(City_or_County)
Categorical

Distinct count7
Unique (%)0.3%
Missing (%)96.3%
Missing (n)1950
Spokane
 
64
Spokane Valley
 
5
Airway Heights
 
2
Other values (3)
 
4
(Missing)
1950
ValueCountFrequency (%) 
Spokane 64 3.2%
 
Spokane Valley 5 0.2%
 
Airway Heights 2 0.1%
 
SCO Spokane 2 0.1%
 
SCO Chattaroy 1 < 0.1%
 
Deer Park 1 < 0.1%
 
(Missing) 1950 96.3%
 
Max length14
Mean length3.180246914
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

perm_leaver
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
0
1444
1
581
ValueCountFrequency (%) 
0 1444 71.3%
 
1 581 28.7%
 

Prevention_|_Most_Recent_Enrollment
Categorical

Distinct count36
Unique (%)1.8%
Missing (%)96.2%
Missing (n)1948
12/08/2017 - 07/11/2018: GI--SSVF--Priority I--HP
 
8
10/15/2018 - 03/06/2019: County--HP--Prevention Plus (176)
 
6
08/11/2014 - 10/13/2014: SNAP--HP--Neighborhood Initiative (106)
 
6
Other values (32)
 
57
(Missing)
1948
ValueCountFrequency (%) 
12/08/2017 - 07/11/2018: GI--SSVF--Priority I--HP 8 0.4%
 
10/15/2018 - 03/06/2019: County--HP--Prevention Plus (176) 6 0.3%
 
08/11/2014 - 10/13/2014: SNAP--HP--Neighborhood Initiative (106) 6 0.3%
 
11/06/2014 - 06/05/2015: GI--SSVF--Priority II--HP 4 0.2%
 
12/14/2018 - 03/14/2019: County--HP--Prevention Plus (176) 4 0.2%
 
11/03/2015 - 12/31/2015: County--HP--Prevention (179) 4 0.2%
 
03/07/2019 - 08/08/2019: GI--HP--SSVF 4 0.2%
 
02/12/2015 - 02/27/2015: CC Partnership--HP--Prevention 3 0.1%
 
04/17/2018 - 03/25/2019: County--HP--Prevention Plus (176) 3 0.1%
 
05/29/2018 - 03/29/2019: County--HP--Prevention Plus (176) 3 0.1%
 
Other values (25) 32 1.6%
 
(Missing) 1948 96.2%
 
Max length69
Mean length4.90617284
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

ProgramType
Constant

This variable is constant and should be ignored for analysis

Constant value1

PSH_|_Most_Recent_Enrollment
Categorical

Distinct count13
Unique (%)0.6%
Missing (%)98.8%
Missing (n)2001
11/15/2016 - 04/21/2017: CC--PSH--WA0248--Good Grounding
 
6
07/24/2014 - 04/03/2016: CC--PSH--WA0248--Good Grounding
 
4
10/04/2013 - 01/14/2016: CC--PSH--WA0248--Good Grounding
 
3
Other values (9)
 
11
(Missing)
2001
ValueCountFrequency (%) 
11/15/2016 - 04/21/2017: CC--PSH--WA0248--Good Grounding 6 0.3%
 
07/24/2014 - 04/03/2016: CC--PSH--WA0248--Good Grounding 4 0.2%
 
10/04/2013 - 01/14/2016: CC--PSH--WA0248--Good Grounding 3 0.1%
 
11/08/2015 - 11/07/2016: Transitions--PSH--WA0265--Scattered Sites 3 0.1%
 
12/04/2015 - Current: HCHV--PSH--VASH 1 < 0.1%
 
04/24/2015 - 10/12/2015: NH--PSH--WA0111--Scattered Sites 1 < 0.1%
 
01/09/2014 - 10/06/2015: CC--PSH--Agnes Kehoe 1 < 0.1%
 
06/06/2019 - Current: CC--PSH--FCS CBRA 1 < 0.1%
 
03/26/2019 - Current: CC--PSH--FCS CBRA 1 < 0.1%
 
01/24/2013 - 08/29/2014: CC--PSH--Father Bach Haven 1 < 0.1%
 
Other values (2) 2 0.1%
 
(Missing) 2001 98.8%
 
Max length66
Mean length3.606419753
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

R10_Pregnancy_Due_Date
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

R10_Pregnancy_Status
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

R1_Referral_Source
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

R2_Date_Status_Determined
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

R2_Enroll_Status
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

R2_Reason_Why_No_Services_Funded
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

R2_Runaway_Youth
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

R3_Sexual_Orientation
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

R4_Last_Grade_Completed
Categorical

Distinct count11
Unique (%)0.5%
Missing (%)86.5%
Missing (n)1752
Nursery School to 4th Grade
 
97
No School Completed
 
46
Refused
 
46
Other values (7)
 
84
(Missing)
1752
ValueCountFrequency (%) 
Nursery School to 4th Grade 97 4.8%
 
No School Completed 46 2.3%
 
Refused 46 2.3%
 
Data not collected 33 1.6%
 
7th Grade or 8th Grade 18 0.9%
 
5th Grade or 6th Grade 18 0.9%
 
10th Grade 6 0.3%
 
11th Grade 5 0.2%
 
9th Grade 3 0.1%
 
School program does not have grade levels 1 < 0.1%
 
(Missing) 1752 86.5%
 
Max length41
Mean length5.251851852
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

R5_School_Status
Categorical

Distinct count8
Unique (%)0.4%
Missing (%)90.7%
Missing (n)1836
Attending school regularly
 
116
Obtained GED
 
46
Client refused
 
11
Other values (4)
 
16
(Missing)
1836
ValueCountFrequency (%) 
Attending school regularly 116 5.7%
 
Obtained GED 46 2.3%
 
Client refused 11 0.5%
 
Attending school irregularly 10 0.5%
 
Data not collected 4 0.2%
 
Graduated from high school 1 < 0.1%
 
Dropped out 1 < 0.1%
 
(Missing) 1836 90.7%
 
Max length28
Mean length4.750123457
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

R6_Employed_Status
Boolean

Distinct count3
Unique (%)0.1%
Missing (%)81.2%
Missing (n)1645
No
362
Yes
 
18
(Missing)
1645
ValueCountFrequency (%) 
No 362 17.9%
 
Yes 18 0.9%
 
(Missing) 1645 81.2%
 

R6_Looking_for_Work
Categorical

Distinct count2
Unique (%)0.1%
Missing (%)> 99.9%
Missing (n)2024
Yes
 
1
(Missing)
2024
ValueCountFrequency (%) 
Yes 1 < 0.1%
 
(Missing) 2024 > 99.9%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

R6_Type_of_Employment
Categorical

Distinct count4
Unique (%)0.2%
Missing (%)99.1%
Missing (n)2006
Full-Time
 
11
Part-Time
 
6
Seasonal / sporadic (including day labor)
 
2
(Missing)
2006
ValueCountFrequency (%) 
Full-Time 11 0.5%
 
Part-Time 6 0.3%
 
Seasonal / sporadic (including day labor) 2 0.1%
 
(Missing) 2006 99.1%
 
Max length41
Mean length3.087901235
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

R6_Why_Not_Employed
Categorical

Distinct count4
Unique (%)0.2%
Missing (%)82.1%
Missing (n)1663
Unable to work
 
235
Looking for work
 
104
Not looking for work
 
23
(Missing)
1663
ValueCountFrequency (%) 
Unable to work 235 11.6%
 
Looking for work 104 5.1%
 
Not looking for work 23 1.1%
 
(Missing) 1663 82.1%
 
Max length20
Mean length5.137283951
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

R7_General_Health_Status
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

R8_Dental_Health_Status
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

R9_Mental_Health_Status
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

RRH_Date_Of_Move-In
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

RRH_In_Permanent_Housing
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

RRH_|_Most_Recent_Enrollment
Categorical

Distinct count327
Unique (%)16.1%
Missing (%)40.9%
Missing (n)828
05/15/2018 - 07/31/2018: CC Partnership--RRH--Rehousing (CHG)
 
18
10/28/2019 - Current: CC--RRH--WA0288--Rapid Rehousing
 
17
04/11/2017 - 06/30/2017: CC--RRH--WA0302--Rapid Rehousing for Families
 
14
Other values (323)
1148
(Missing)
828
ValueCountFrequency (%) 
05/15/2018 - 07/31/2018: CC Partnership--RRH--Rehousing (CHG) 18 0.9%
 
10/28/2019 - Current: CC--RRH--WA0288--Rapid Rehousing 17 0.8%
 
04/11/2017 - 06/30/2017: CC--RRH--WA0302--Rapid Rehousing for Families 14 0.7%
 
04/30/2019 - 06/03/2019: CC--RRH--WA0288--Rapid Rehousing 14 0.7%
 
01/14/2019 - Current: CC--RRH--WA0288--Rapid Rehousing 12 0.6%
 
11/05/2018 - 12/12/2018: CC--RRH--WA0288--Rapid Rehousing 12 0.6%
 
06/11/2019 - 07/18/2019: CC Partnership--RRH--Rehousing (CHG) 11 0.5%
 
12/12/2018 - 12/27/2018: CC--RRH--WA0353--RRH for HH with Children 10 0.5%
 
09/17/2019 - 10/29/2019: CC--RRH--WA0288--Rapid Rehousing 10 0.5%
 
05/22/2019 - 07/03/2019: CC Partnership--RRH--Rehousing (CHG) 10 0.5%
 
Other values (316) 1069 52.8%
 
(Missing) 828 40.9%
 
Max length71
Mean length37.50765432
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

SOAR_Eligibility_Determination_(Most_Recent)
Categorical

Distinct count7
Unique (%)0.3%
Missing (%)99.5%
Missing (n)2014
SOAR Eligibility Determination - Service Date: 04/02/2019
 
3
SOAR Eligibility Determination - Service Date: 12/04/2018
 
3
SOAR Eligibility Determination - Service Date: 12/12/2018
 
2
Other values (3)
 
3
(Missing)
2014
ValueCountFrequency (%) 
SOAR Eligibility Determination - Service Date: 04/02/2019 3 0.1%
 
SOAR Eligibility Determination - Service Date: 12/04/2018 3 0.1%
 
SOAR Eligibility Determination - Service Date: 12/12/2018 2 0.1%
 
SOAR Eligibility Determination - Service Date: 10/14/2019 1 < 0.1%
 
SOAR Eligibility Determination - Service Date: 08/27/2019 1 < 0.1%
 
SOAR Eligibility Determination - Service Date: 10/22/2019 1 < 0.1%
 
(Missing) 2014 99.5%
 
Max length57
Mean length3.293333333
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

SOAR_Enrollment_Determination_(Most_Recent)
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

Street_Outreach_|_Most_Recent_Enrollment
Categorical

Distinct count46
Unique (%)2.3%
Missing (%)97.1%
Missing (n)1967
11/04/2019 - Current: VOA--SSO--Youthreach
 
4
08/05/2019 - 12/02/2019: Transitions--SSO--WA0125--Womens Hearth
 
3
04/17/2019 - Current: Transitions--SSO--WA0125--Womens Hearth
 
3
Other values (42)
 
48
(Missing)
1967
ValueCountFrequency (%) 
11/04/2019 - Current: VOA--SSO--Youthreach 4 0.2%
 
08/05/2019 - 12/02/2019: Transitions--SSO--WA0125--Womens Hearth 3 0.1%
 
04/17/2019 - Current: Transitions--SSO--WA0125--Womens Hearth 3 0.1%
 
08/21/2019 - 12/04/2019: Transitions--SSO--WA0125--Womens Hearth 3 0.1%
 
03/06/2017 - Current: VOA--SSO--Community Cares 2 0.1%
 
06/05/2019 - 10/16/2019: Transitions--SSO--WA0125--Womens Hearth 2 0.1%
 
08/06/2019 - 12/02/2019: Transitions--SSO--WA0125--Womens Hearth 2 0.1%
 
12/03/2019 - Current: VOA--SSO--Youthreach 2 0.1%
 
06/21/2019 - Current: Transitions--SSO--WA0125--Womens Hearth 1 < 0.1%
 
05/19/2019 - 09/17/2019: Transitions--SSO--WA0125--Womens Hearth 1 < 0.1%
 
Other values (35) 35 1.7%
 
(Missing) 1967 97.1%
 
Max length64
Mean length4.480987654
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Transitional_Housing_|_Most_Recent_Enrollment
Categorical

Distinct count75
Unique (%)3.7%
Missing (%)90.4%
Missing (n)1831
09/14/2018 - 10/30/2018: CC--TH--WA0109--SMS
 
12
12/17/2015 - 04/14/2016: TSA--TH--Stepping Stones
 
8
12/13/2017 - 07/01/2018: TSA--TH--Stepping Stones
 
8
Other values (71)
 
166
(Missing)
1831
ValueCountFrequency (%) 
09/14/2018 - 10/30/2018: CC--TH--WA0109--SMS 12 0.6%
 
12/17/2015 - 04/14/2016: TSA--TH--Stepping Stones 8 0.4%
 
12/13/2017 - 07/01/2018: TSA--TH--Stepping Stones 8 0.4%
 
05/01/2019 - 11/11/2019: TSA--TH--Stepping Stones 7 0.3%
 
11/28/2018 - 04/15/2019: TSA--TH--Stepping Stones 7 0.3%
 
08/16/2019 - Current: TSA--TH--Stepping Stones 6 0.3%
 
01/16/2013 - 03/05/2013: TSA--TH--Stepping Stones 6 0.3%
 
01/04/2019 - Current: TSA--TH--Stepping Stones 6 0.3%
 
08/29/2017 - 01/15/2018: Transitions--TH--TLC 5 0.2%
 
05/03/2019 - Current: TSA--TH--Stepping Stones 5 0.2%
 
Other values (64) 124 6.1%
 
(Missing) 1831 90.4%
 
Max length62
Mean length7.412345679
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Under_25_Years_Old
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Yes
1165
No
860
ValueCountFrequency (%) 
Yes 1165 57.5%
 
No 860 42.5%
 

V5_Last_Permanent_Address
Categorical

Distinct count6
Unique (%)0.3%
Missing (%)67.9%
Missing (n)1374
Full address reported
304
Incomplete or estimated address reported
 
215
Client refused
 
69
Other values (2)
 
63
(Missing)
1374
ValueCountFrequency (%) 
Full address reported 304 15.0%
 
Incomplete or estimated address reported 215 10.6%
 
Client refused 69 3.4%
 
Data not collected 54 2.7%
 
Client doesn't know 9 0.4%
 
(Missing) 1374 67.9%
 
Max length40
Mean length10.47654321
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

V5_Prior_Address
Categorical

Distinct count249
Unique (%)12.3%
Missing (%)84.3%
Missing (n)1708
204 E Indiana Ave
 
10
1809 E Longfellow
 
5
1918 E Central Ave
 
4
Other values (245)
 
298
(Missing)
1708
ValueCountFrequency (%) 
204 E Indiana Ave 10 0.5%
 
1809 E Longfellow 5 0.2%
 
1918 E Central Ave 4 0.2%
 
2309 E Euclid Ave 4 0.2%
 
16412 E Sprague 3 0.1%
 
3110 S Mt Vernon #27 3 0.1%
 
319 N Locust Rd 3 0.1%
 
170 W. Front ST. 3 0.1%
 
2524 N Cincinnati St 3 0.1%
 
717 E St 3 0.1%
 
Other values (238) 276 13.6%
 
(Missing) 1708 84.3%
 
Max length28
Mean length4.961975309
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

V5_State
Categorical

Distinct count23
Unique (%)1.1%
Missing (%)75.8%
Missing (n)1534
WA
395
ID
 
14
CA
 
14
Other values (19)
 
68
(Missing)
1534
ValueCountFrequency (%) 
WA 395 19.5%
 
ID 14 0.7%
 
CA 14 0.7%
 
UT 11 0.5%
 
MT 10 0.5%
 
WI 7 0.3%
 
IN 6 0.3%
 
LA 4 0.2%
 
IA 4 0.2%
 
FL 4 0.2%
 
Other values (12) 22 1.1%
 
(Missing) 1534 75.8%
 
Max length3
Mean length2.757530864
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

V5_Zip
Numeric

Distinct count90
Unique (%)4.4%
Missing (%)75.8%
Missing (n)1534
Infinite (%)0.0%
Infinite (n)0
Mean93371.69043
Minimum21244
Maximum99403
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum21244
5-th percentile53206
Q199001
Median99201
Q399207
95-th percentile99223
Maximum99403
Range78159
Interquartile range206

Descriptive statistics

Standard deviation14818.30803
Coef of variation0.1587023643
Kurtosis7.351560515
Mean93371.69043
MAD9383.663449
Skewness-2.824607254
Sum45845500
Variance219582253
Memory size15.9 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
99201 60 3.0%
 
99207 57 2.8%
 
99206 35 1.7%
 
99205 27 1.3%
 
99208 25 1.2%
 
99202 25 1.2%
 
99001 15 0.7%
 
99037 15 0.7%
 
99217 13 0.6%
 
99223 12 0.6%
 
Other values (79) 207 10.2%
 
(Missing) 1534 75.8%
 

Minimum 5 values

ValueCountFrequency (%) 
21244 3 0.1%
 
32640 2 0.1%
 
33905 1 < 0.1%
 
34957 1 < 0.1%
 
38109 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
99403 1 < 0.1%
 
99362 5 0.2%
 
99224 9 0.4%
 
99223 12 0.6%
 
99220 1 < 0.1%
 

WorkSource_Referral_Most_Recent
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

YAHP_Referral_Most_Recent
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

Correlations

Missing values

Sample

First rows

2.1_Organization_Name2.2_Project_Name2.4_ProjectType2.5_Utilization_Tracking_Method_(Invalid)2.6_Federal_Grant_Programs3.10_Enroll_Date3.11_Exit_Date3.12_Exit_Destination3.15_Relationship_to_HoH3.16_Client_Location3.1_FirstName3.1_LastName3.2_Social_Security_Quality3.2_SocSecNo3.3_Birthdate3.3_Birthdate_Quality3.4_Race3.5_Ethnicity3.6_Gender3.7_Veteran_Status3.8_Disabling_Condition_at_Entry3.917_Homeless_Start_Date3.917_Length_of_Stay3.917_Living_Situation3.917_Stayed_Less_Than_90_Days3.917_Times_Homeless_Last_3_Years3.917_Total_Months_Homeless_Last_3_Years3.917b_Stayed_in_Streets,_ES_or_SH_Night_Before3.917b_Stayed_Less_Than_7_Nights4.05_Physical_Disability4.06_Developmental_Disability4.07_Chronic_Health_Condition4.08_HIV/AIDS4.09_Mental_Health_Problem4.10_Alcohol_Abuse_(Substance_Abuse)4.10_Drug_Abuse_(Substance_Abuse)4.11_Domestic_Violence4.11_Domestic_Violence_-_Currently_Fleeing_DV?4.11_Domestic_Violence_-_When_it_Occurred4.12_Contact_Services4.13_Engagement_Date4.1_Housing_Status4.24_Connected_to_McKinney_Vento_Liason_(Retired)4.24_Current_Status_(Retired_Data_Element)4.24_In_School_(Retired_Data_Element)4.2_Income_Total_at_Entry4.2_Income_Total_at_Exit4.3_Non-Cash_Benefit_Count4.3_Non-Cash_Benefit_Count_at_Exit4.4_Covered_by_Health_Insurance5.8_Personal_ID5.9_Household_IDAge_at_EnrollmentBarrier_Count_at_EntryBed_Nights_During_Report_PeriodCaseAdultsCaseChildrenCaseMembersChronic_Homeless_StatusClient_Record_RestrictedClientIDCoordinated_Entry_|_Most_Recent_EnrollmentCount_of_Bed_Nights_(Housing_Check-ins)Count_of_Bed_Nights_-_Entire_EpisodeCurrent_AgeCurrentDateDate_of_First_Contact_(Beta)Date_of_First_ES_Stay_(Beta)Date_of_Last_Contact_(Beta)Date_of_Last_ES_Stay_(Beta)Days_Enrolled_in_ProjectDays_Enrolled_Until_Engagement_DateDays_Enrolled_Until_RRH_Date_of_Move-inEmergency_Shelter_|_Most_Recent_EnrollmentEnrollment_Created_ByHEN-HP_Referral_Most_RecentHEN-RRH_Referral_Most_RecentHousehold_TypeInfoReleaseNoInformation_Release_StatusLatitudeLength_of_Time_Homeless_(3.917_Approximate_Start)LongitudeMunicipality_(City_or_County)perm_leaverPrevention_|_Most_Recent_EnrollmentProgramTypePSH_|_Most_Recent_EnrollmentR10_Pregnancy_Due_DateR10_Pregnancy_StatusR1_Referral_SourceR2_Date_Status_DeterminedR2_Enroll_StatusR2_Reason_Why_No_Services_FundedR2_Runaway_YouthR3_Sexual_OrientationR4_Last_Grade_CompletedR5_School_StatusR6_Employed_StatusR6_Looking_for_WorkR6_Type_of_EmploymentR6_Why_Not_EmployedR7_General_Health_StatusR8_Dental_Health_StatusR9_Mental_Health_StatusRRH_Date_Of_Move-InRRH_In_Permanent_HousingRRH_|_Most_Recent_EnrollmentSOAR_Eligibility_Determination_(Most_Recent)SOAR_Enrollment_Determination_(Most_Recent)Street_Outreach_|_Most_Recent_EnrollmentTransitional_Housing_|_Most_Recent_EnrollmentUnder_25_Years_OldV5_Last_Permanent_AddressV5_Prior_AddressV5_StateV5_ZipWorkSource_Referral_Most_RecentYAHP_Referral_Most_Recent
0Family Promise of SpokaneFPS--ES--Bridges Family ShelterEmergency shelterEntry/Exit (e/e)NaN2015-11-082016-05-08Staying or living with family, permanent tenureSelfSpokane City & County CoCAnonymousAnonymousData not collectedNaN1973-01-01Approximate or Partial DOB ReportedWhiteNon-Hispanic/LatinoFemaleNoYes2015-10-01One month or more, but less than 90 daysPlace not meant for habitationNaNData not collectedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNYesNoOne year ago or more0NaTNaNNaNNaNNaNNaNNaN10No587246604642.00NaN1340True103/28/2019 - 07/08/2019: CC--CA-HFCA1NaN46.02019-12-04 21:12:14.183NaT2015-11-08NaT2015-11-08182No Engagement DateNo Move-In Date08/24/2017 - 09/27/2017: TSA--ES--Family ShelterRenee NorrisNaNNaNHousehold with Adults and Children500.0Client may be seen by othersNaN220.0NaNNaN1.0NaN1NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN09/25/2017 - 10/26/2017: CC--RRH--WA0353--RRH for HH with ChildrenNaNNaNNaNNaNNoData not collectedNaNNaNNaNNaNNaN
1Family Promise of SpokaneFPS--ES--Bridges Family ShelterEmergency shelterEntry/Exit (e/e)NaN2015-11-082016-05-08Staying or living with family, permanent tenureDaughterNaNAnonymousAnonymousData not collectedNaN2003-01-01Approximate or Partial DOB ReportedWhiteNon-Hispanic/LatinoFemaleNaNData not collectedNaTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaTNaNYesYesNaNNaNNaN00Yes587276604612.00NaN1340True108/14/2017 - 03/27/2019: CC--CA-HFCA1NaN16.02019-12-04 21:12:14.183NaT2015-11-08NaT2015-11-08182No Engagement DateNo Move-In Date08/24/2017 - 09/27/2017: TSA--ES--Family ShelterRenee NorrisNaNNaNHousehold with Adults and Children500.0Client may be seen by othersNaNNaNNaNNaN1.0NaN1NaNNaNNaNNaNNaNNaNNaNNaNNaN7th Grade or 8th GradeAttending school regularlyNaNNaNNaNNaNNaNNaNNaNNaNNaN09/25/2017 - 10/26/2017: CC--RRH--WA0353--RRH for HH with ChildrenNaNNaNNaNNaNYesNaNNaNNaNNaNNaNNaN
2Family Promise of SpokaneFPS--ES--Bridges Family ShelterEmergency shelterEntry/Exit (e/e)NaN2015-11-082016-05-08Staying or living with family, permanent tenureDaughterNaNAnonymousAnonymousData not collectedNaN2011-01-01Approximate or Partial DOB ReportedWhiteNon-Hispanic/LatinoFemaleNaNData not collectedNaTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaTNaNNaNNoNaNNaNNaN00Yes58725660464.00NaN1340True103/28/2019 - 07/08/2019: CC--CA-HFCA1NaN8.02019-12-04 21:12:14.183NaT2015-11-08NaT2015-11-08182No Engagement DateNo Move-In Date08/24/2017 - 09/27/2017: TSA--ES--Family ShelterRenee NorrisNaNNaNHousehold with Adults and Children500.0Client may be seen by othersNaNNaNNaNNaN1.0NaN1NaNNaNNaNNaNNaNNaNNaNNaNNaNNo School CompletedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN09/25/2017 - 10/26/2017: CC--RRH--WA0353--RRH for HH with ChildrenNaNNaNNaNNaNYesNaNNaNNaNNaNNaNNaN
3Family Promise of SpokaneFPS--ES--Bridges Family ShelterEmergency shelterEntry/Exit (e/e)NaN2015-11-082016-05-08Staying or living with family, permanent tenureSonNaNAnonymousAnonymousData not collectedNaN2014-01-01Approximate or Partial DOB ReportedWhiteNon-Hispanic/LatinoMaleNaNData not collectedNaTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaTNaNNaNNoNaNNaNNaN00Yes58726660461.00NaN1340True103/28/2019 - 07/08/2019: CC--CA-HFCA1NaN5.02019-12-04 21:12:14.183NaT2015-11-08NaT2015-11-08182No Engagement DateNo Move-In Date08/24/2017 - 09/27/2017: TSA--ES--Family ShelterRenee NorrisNaNNaNHousehold with Adults and Children500.0Client may be seen by othersNaNNaNNaNNaN1.0NaN1NaNNaNNaNNaNNaNNaNNaNNaNNaNNo School CompletedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN09/25/2017 - 10/26/2017: CC--RRH--WA0353--RRH for HH with ChildrenNaNNaNNaNNaNYesNaNNaNNaNNaNNaNNaN
4Family Promise of SpokaneFPS--ES--Bridges Family ShelterEmergency shelterEntry/Exit (e/e)NaN2015-11-022016-02-13Rental by client, no ongoing housing subsidySelfSpokane City & County CoCMichelleChristieFull SSN534-84-79411969-05-10Full DOB ReportedWhiteNon-Hispanic/LatinoFemaleNoYes2015-10-19One week or more, but less than one monthPlace not meant for habitationNaNOne timeOne month (this time is the first month)NaNNaNPhysical DisabilityNaNChronic HealthNaNMental IllnessNaNNaNYesNoOne year ago or more0NaTCategory 1 - HomelessNaNNaNNaN2100.02348.012Yes632366656346.03NaN2130True1NaN1NaN50.02019-12-04 21:12:14.183NaT2015-11-03NaT2015-11-03103No Engagement DateNo Move-In Date11/02/2015 - 02/13/2016: FPS--ES--Bridges Family ShelterRenee NorrisNaNNaNHousehold with Adults and Children500.0Client may be seen by othersNaN117.0NaNNaN1.0NaN1NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNoFull address reported2720 E RichWA99207.0NaNNaN
5Family Promise of SpokaneFPS--ES--Bridges Family ShelterEmergency shelterEntry/Exit (e/e)NaN2015-11-022016-02-13Rental by client, no ongoing housing subsidySonNaNAlbertChristieFull SSN533-41-35721998-08-25Full DOB ReportedWhiteNon-Hispanic/LatinoMaleNaNMissingNaTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaTCategory 1 - HomelessYesYesNaNNaNNaN00Yes632396656317.00NaN2130True1NaN0NaN21.02019-12-04 21:12:14.183NaTNaTNaTNaT103No Engagement DateNo Move-In Date11/02/2015 - 02/13/2016: FPS--ES--Bridges Family ShelterRenee NorrisNaNNaNHousehold with Adults and Children500.0Client may be seen by othersNaNNaNNaNNaN1.0NaN1NaNNaNNaNNaNNaNNaNNaNNaNNaN11th GradeAttending school regularlyNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNYesNaNNaNNaNNaNNaNNaN
6Family Promise of SpokaneFPS--ES--Bridges Family ShelterEmergency shelterEntry/Exit (e/e)NaN2015-12-172016-02-13Rental by client, no ongoing housing subsidyDaughterNaNEmmaChirstieFull SSN537-33-10991995-08-09Full DOB ReportedWhiteNon-Hispanic/LatinoFemaleNoYesNaTOne month or more, but less than 90 daysStaying or living in a family member's room, apartment or houseNaNOne timeOne month (this time is the first month)NaNNaNNaNNaNNaNNaNNaNNaNNaNNoNaNNaN0NaTCategory 1 - HomelessNaNNaNNaNNaN240.020Yes638716656320.00NaN2130True1NaN0NaN24.02019-12-04 21:12:14.183NaTNaTNaTNaT58No Engagement DateNo Move-In Date12/17/2015 - 02/13/2016: FPS--ES--Bridges Family ShelterRenee NorrisNaNNaNHousehold with Adults and Children500.0Client may be seen by othersNaNNaNNaNNaN1.0NaN1NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNYesFull address reported2720 E RichWA99207.0NaNNaN
7Family Promise of SpokaneFPS--ES--Bridges Family ShelterEmergency shelterEntry/Exit (e/e)NaN2016-02-242016-05-24Place not meant for habitation (e.g., a vehicle, an abandoned building, bus/train/subway station/airport or anywhere outside)SelfSpokane City & County CoCChrystalLormerFull SSN549-93-79911984-11-13Full DOB ReportedWhiteNon-Hispanic/LatinoFemaleNoYesNaT90 days or more, but less than one yearRental by client, no ongoing housing subsidyNaNThree times12NaNNaNNaNNaNNaNNaNMental IllnessNaNDrug AbuseYesNoThree to six months ago (excluding six months exactly)0NaTCategory 1 - HomelessNaNNaNNaN521.0521.043Yes489526990831.02NaN1230True103/14/2018 - 02/28/2019: SNAP--CA--SHCA0NaN35.02019-12-04 21:12:14.183NaTNaTNaTNaT90No Engagement DateNo Move-In Date01/26/2018 - 02/21/2018: TSA--ES--Family ShelterRenee NorrisNaNNaNHousehold with Adults and Children500.0Client may be seen by othersNaNNaNNaNNaN0.0NaN1NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN03/21/2018 - 02/28/2019: SNAP--RRH--City CHG (164)NaNNaNNaN05/04/2015 - 10/31/2015: SNAP--TH--WA0118--RRAP Housing (167)NoFull address reported212 E WedgewoodWA99208.0NaNNaN
8Family Promise of SpokaneFPS--ES--Bridges Family ShelterEmergency shelterEntry/Exit (e/e)NaN2016-02-242016-05-09Foster Care Home or Foster Care Group HomeSonNaNNickolasLormerFull SSN513-79-78542009-11-16Full DOB ReportedWhiteNon-Hispanic/LatinoMaleNoNoNaTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaTCategory 1 - HomelessYesYesNaNNaNNaN00Yes48953699086.00NaN1230True101/16/2018 - 12/31/2018: CC--CA-HFCA1NaN10.02019-12-04 21:12:14.183NaT2016-02-24NaT2016-02-2475No Engagement DateNo Move-In Date01/26/2018 - 02/17/2018: TSA--ES--Family ShelterRenee NorrisNaNNaNHousehold with Adults and Children500.0Client may be seen by othersNaNNaNNaNNaN0.0NaN1NaNNaNNaNNaNNaNNaNNaNNaNNaNNo School CompletedAttending school regularlyNaNNaNNaNNaNNaNNaNNaNNaNNaN05/03/2016 - 06/15/2016: CC--RRH--WA0302--Rapid Rehousing for FamiliesNaNNaNNaN05/04/2015 - 10/31/2015: SNAP--TH--WA0118--RRAP Housing (167)YesNaNNaNNaNNaNNaNNaN
9Family Promise of SpokaneFPS--ES--Bridges Family ShelterEmergency shelterEntry/Exit (e/e)NaN2016-02-242016-05-09Foster Care Home or Foster Care Group HomeSonNaNJacksonLormerFull SSN234-97-05872015-06-07Full DOB ReportedWhiteNon-Hispanic/LatinoMaleNaNNoNaTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaTCategory 1 - HomelessNaNNoNaNNaNNaN00Yes60667699080.00NaN1230True104/26/2016 - 06/01/2017: CC--CA-HFCA1NaN4.02019-12-04 21:12:14.183NaT2016-02-24NaT2016-02-2475No Engagement DateNo Move-In Date01/26/2018 - 02/21/2018: TSA--ES--Family ShelterRenee NorrisNaNNaNHousehold with Adults and Children500.0Client may be seen by othersNaNNaNNaNNaN0.0NaN1NaNNaNNaNNaNNaNNaNNaNNaNNaNNo School CompletedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN05/03/2016 - 06/15/2016: CC--RRH--WA0302--Rapid Rehousing for FamiliesNaNNaNNaN06/18/2015 - 10/31/2015: SNAP--TH--WA0118--RRAP Housing (167)YesNaNNaNNaNNaNNaNNaN

Last rows

2.1_Organization_Name2.2_Project_Name2.4_ProjectType2.5_Utilization_Tracking_Method_(Invalid)2.6_Federal_Grant_Programs3.10_Enroll_Date3.11_Exit_Date3.12_Exit_Destination3.15_Relationship_to_HoH3.16_Client_Location3.1_FirstName3.1_LastName3.2_Social_Security_Quality3.2_SocSecNo3.3_Birthdate3.3_Birthdate_Quality3.4_Race3.5_Ethnicity3.6_Gender3.7_Veteran_Status3.8_Disabling_Condition_at_Entry3.917_Homeless_Start_Date3.917_Length_of_Stay3.917_Living_Situation3.917_Stayed_Less_Than_90_Days3.917_Times_Homeless_Last_3_Years3.917_Total_Months_Homeless_Last_3_Years3.917b_Stayed_in_Streets,_ES_or_SH_Night_Before3.917b_Stayed_Less_Than_7_Nights4.05_Physical_Disability4.06_Developmental_Disability4.07_Chronic_Health_Condition4.08_HIV/AIDS4.09_Mental_Health_Problem4.10_Alcohol_Abuse_(Substance_Abuse)4.10_Drug_Abuse_(Substance_Abuse)4.11_Domestic_Violence4.11_Domestic_Violence_-_Currently_Fleeing_DV?4.11_Domestic_Violence_-_When_it_Occurred4.12_Contact_Services4.13_Engagement_Date4.1_Housing_Status4.24_Connected_to_McKinney_Vento_Liason_(Retired)4.24_Current_Status_(Retired_Data_Element)4.24_In_School_(Retired_Data_Element)4.2_Income_Total_at_Entry4.2_Income_Total_at_Exit4.3_Non-Cash_Benefit_Count4.3_Non-Cash_Benefit_Count_at_Exit4.4_Covered_by_Health_Insurance5.8_Personal_ID5.9_Household_IDAge_at_EnrollmentBarrier_Count_at_EntryBed_Nights_During_Report_PeriodCaseAdultsCaseChildrenCaseMembersChronic_Homeless_StatusClient_Record_RestrictedClientIDCoordinated_Entry_|_Most_Recent_EnrollmentCount_of_Bed_Nights_(Housing_Check-ins)Count_of_Bed_Nights_-_Entire_EpisodeCurrent_AgeCurrentDateDate_of_First_Contact_(Beta)Date_of_First_ES_Stay_(Beta)Date_of_Last_Contact_(Beta)Date_of_Last_ES_Stay_(Beta)Days_Enrolled_in_ProjectDays_Enrolled_Until_Engagement_DateDays_Enrolled_Until_RRH_Date_of_Move-inEmergency_Shelter_|_Most_Recent_EnrollmentEnrollment_Created_ByHEN-HP_Referral_Most_RecentHEN-RRH_Referral_Most_RecentHousehold_TypeInfoReleaseNoInformation_Release_StatusLatitudeLength_of_Time_Homeless_(3.917_Approximate_Start)LongitudeMunicipality_(City_or_County)perm_leaverPrevention_|_Most_Recent_EnrollmentProgramTypePSH_|_Most_Recent_EnrollmentR10_Pregnancy_Due_DateR10_Pregnancy_StatusR1_Referral_SourceR2_Date_Status_DeterminedR2_Enroll_StatusR2_Reason_Why_No_Services_FundedR2_Runaway_YouthR3_Sexual_OrientationR4_Last_Grade_CompletedR5_School_StatusR6_Employed_StatusR6_Looking_for_WorkR6_Type_of_EmploymentR6_Why_Not_EmployedR7_General_Health_StatusR8_Dental_Health_StatusR9_Mental_Health_StatusRRH_Date_Of_Move-InRRH_In_Permanent_HousingRRH_|_Most_Recent_EnrollmentSOAR_Eligibility_Determination_(Most_Recent)SOAR_Enrollment_Determination_(Most_Recent)Street_Outreach_|_Most_Recent_EnrollmentTransitional_Housing_|_Most_Recent_EnrollmentUnder_25_Years_OldV5_Last_Permanent_AddressV5_Prior_AddressV5_StateV5_ZipWorkSource_Referral_Most_RecentYAHP_Referral_Most_Recent
2015Family Promise of SpokaneFPS--ES--Open DoorsEmergency shelterNight-by-Night (nbn)NaN2019-11-27NaTNaNSelfSpokane City & County CoCBrittanyParrFull SSN612-11-36671996-08-19Full DOB ReportedWhiteNon-Hispanic/LatinoFemaleNoNo2019-09-27Two to six nightsStaying or living in a family member's room, apartment or houseNaNTwo times6NaNNaNNaNNaNChronic HealthNaNNaNNaNNaNYesYesWithin the past three months0NaTCategory 1 - HomelessNaNNaNNaNNaNNaN10Yes7677812491723.012.02240True103/07/2018 - 12/31/2018: CC--CA-HFCA22.023.02019-12-04 21:12:14.183NaT2019-11-27NaT2019-11-287No Engagement DateNo Move-In Date11/27/2019 - Current: FPS--ES--Open DoorsKermit NelsonNaNNaNHousehold with Adults and Children500.0Client may be seen by othersNaN68.0NaNNaN0.0NaN1NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN04/30/2018 - 06/30/2018: CC--RRH--WA0302--Rapid Rehousing for FamiliesNaNNaNNaNNaNYesFull address reported2400 N Wilbur RdWA99206.0NaNNaN
2016Family Promise of SpokaneFPS--ES--Open DoorsEmergency shelterNight-by-Night (nbn)NaN2019-11-27NaTNaNSpouseNaNDuallGladdenFull SSNXXX-XX-20171997-04-14Full DOB ReportedWhiteNon-Hispanic/LatinoMaleNoNo2019-09-27Two to six nightsStaying or living in a family member's room, apartment or houseNaNTwo times6NaNNaNNaNNaNNaNNaNNaNNaNNaNYesYesWithin the past three months0NaTCategory 1 - HomelessNaNNaNNaNNaNNaN10No7677912491722.002.02240False103/07/2018 - 12/31/2018: CC--CA-HFCA22.022.02019-12-04 21:12:14.183NaT2019-11-27NaT2019-11-287No Engagement DateNo Move-In Date11/27/2019 - Current: FPS--ES--Open DoorsKermit NelsonNaNNaNHousehold with Adults and Children500.0Client may be seen by othersNaN68.0NaNNaN0.0NaN1NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN04/30/2018 - 06/30/2018: CC--RRH--WA0302--Rapid Rehousing for FamiliesNaNNaNNaNNaNYesFull address reported2400 N Wilbur RdWA99206.0NaNNaN
2017Family Promise of SpokaneFPS--ES--Open DoorsEmergency shelterNight-by-Night (nbn)NaN2019-11-27NaTNaNSonNaNBraxtonGladdenClient RefusedNaN2016-12-18Full DOB ReportedWhiteNon-Hispanic/LatinoMaleNaNNoNaTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaTNaNNaNNaNNaNNaNNaN00Yes767801249172.002.02240False103/07/2018 - 12/31/2018: CC--CA-HFCA22.02.02019-12-04 21:12:14.183NaT2019-11-27NaT2019-11-287No Engagement DateNo Move-In Date11/27/2019 - Current: FPS--ES--Open DoorsKermit NelsonNaNNaNHousehold with Adults and Children500.0Client may be seen by othersNaNNaNNaNNaN0.0NaN1NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN04/30/2018 - 06/30/2018: CC--RRH--WA0302--Rapid Rehousing for FamiliesNaNNaNNaNNaNYesNaNNaNNaNNaNNaNNaN
2018Family Promise of SpokaneFPS--ES--Open DoorsEmergency shelterNight-by-Night (nbn)NaN2019-11-27NaTNaNDaughterNaNIndicaGladdenClient doesn't knowNaN2019-04-29Full DOB ReportedWhiteNon-Hispanic/LatinoFemaleNaNNoNaTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaTNaNNaNNaNNaNNaNNaN00Yes978161249170.002.02240True1NaN22.00.02019-12-04 21:12:14.183NaT2019-11-27NaT2019-11-287No Engagement DateNo Move-In Date11/27/2019 - Current: FPS--ES--Open DoorsKermit NelsonNaNNaNHousehold with Adults and Children500.0Client may be seen by othersNaNNaNNaNNaN0.0NaN1NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNYesNaNNaNNaNNaNNaNNaN
2019Family Promise of SpokaneFPS--ES--Open DoorsEmergency shelterNight-by-Night (nbn)NaN2019-11-27NaTNaNSelfSpokane City & County CoCNikeeLarsenApproximate or partial SSN reported???-??-32621987-09-27Full DOB ReportedWhiteNon-Hispanic/LatinoFemaleNoYes2019-09-25One week or more, but less than one monthPlace not meant for habitationNaNTwo timesMore than 12 monthsNaNNaNNaNNaNChronic HealthNaNMental IllnessNaNDrug AbuseYesYesWithin the past three months0NaTCategory 1 - HomelessNaNNaNNaNNaNNaN10Yes9781712491832.036.01010True1NaN66.032.02019-12-04 21:12:14.183NaT2019-11-27NaT2019-12-037No Engagement DateNo Move-In Date11/27/2019 - Current: FPS--ES--Open DoorsKermit NelsonNaNNaNHousehold without Children500.0Client may be seen by othersNaN70.0NaNNaN0.0NaN1NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNoFull address reported108 S State StWA99201.0NaNNaN
2020Family Promise of SpokaneFPS--ES--Open DoorsEmergency shelterNight-by-Night (nbn)NaN2019-11-28NaTNaNSelfSpokane City & County CoCKellyCheekinewApproximate or partial SSN reported???-??-86721982-05-22Full DOB ReportedAmerican Indian or Alaska NativeNon-Hispanic/LatinoMaleNoYes2019-11-27One night or lessStaying or living in a family member's room, apartment or houseNaNOne timeOne month (this time is the first month)NaNNaNPhysical DisabilityNaNNaNNaNNaNNaNNaNNoNaNNaN0NaTCategory 1 - HomelessNaNNaNNaN194.0NaN10Yes9781812491937.016.01120True112/04/2019 - Current: CC--CA-HFCA66.037.02019-12-04 21:12:14.183NaT2019-11-28NaT2019-12-036No Engagement DateNo Move-In Date11/28/2019 - Current: FPS--ES--Open DoorsKermit NelsonNaNNaNHousehold with Adults and Children500.0Client may be seen by othersNaN7.0NaNNaN0.0NaN1NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNoFull address reported622 N Herald RdWA99206.0NaNNaN
2021Family Promise of SpokaneFPS--ES--Open DoorsEmergency shelterNight-by-Night (nbn)NaN2019-11-28NaTNaNSonNaNLiamDeafladClient doesn't knowNaN2009-05-01Full DOB ReportedAmerican Indian or Alaska NativeNon-Hispanic/LatinoMaleNaNNoNaTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaTNaNNoYesNaNNaNNaN00Yes9781912491910.006.01120True112/04/2019 - Current: CC--CA-HFCA66.010.02019-12-04 21:12:14.183NaT2019-11-28NaT2019-12-036No Engagement DateNo Move-In Date11/28/2019 - Current: FPS--ES--Open DoorsKermit NelsonNaNNaNHousehold with Adults and Children500.0Client may be seen by othersNaNNaNNaNNaN0.0NaN1NaNNaNNaNNaNNaNNaNNaNNaNNaNNursery School to 4th GradeAttending school regularlyNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNYesNaNNaNNaNNaNNaNNaN
2022Family Promise of SpokaneFPS--ES--Open DoorsEmergency shelterNight-by-Night (nbn)NaN2019-11-29NaTNaNSelfSpokane City & County CoCRosientaKansouFull SSN576-79-13391980-11-26Full DOB ReportedNative Hawaiian or Other Pacific IslanderNon-Hispanic/LatinoFemaleNoNo2019-11-27Two to six nightsPlace not meant for habitationNaNOne timeOne month (this time is the first month)NaNNaNNaNNaNNaNNaNNaNNaNNaNNoNaNNaN0NaTCategory 1 - HomelessNaNNaNNaN800.0NaN10Yes7477812492039.002.01230False111/27/2019 - Current: CC--CA-HFCA22.039.02019-12-04 21:12:14.183NaT2019-11-29NaT2019-11-305No Engagement DateNo Move-In Date11/29/2019 - Current: FPS--ES--Open DoorsKermit NelsonNaNNaNHousehold with Adults and Children500.0Client may be seen by othersNaN7.0NaNNaN0.0NaN1NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN12/03/2019 - Current: CC Partnership--RRH--Rehousing (CHG)NaNNaNNaNNaNNoFull address reported1111 W Shannon AveWA99205.0NaNNaN
2023Family Promise of SpokaneFPS--ES--Open DoorsEmergency shelterNight-by-Night (nbn)NaN2019-11-29NaTNaNSonNaNJamesSamuoFull SSNXXX-XX-10832005-11-01Full DOB ReportedNative Hawaiian or Other Pacific IslanderNon-Hispanic/LatinoMaleNaNNoNaTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaTNaNClient doesn't knowYesNaNNaNNaN00Yes7477912492014.002.01230False111/27/2019 - Current: CC--CA-HFCA22.014.02019-12-04 21:12:14.183NaT2019-11-29NaT2019-11-305No Engagement DateNo Move-In Date11/29/2019 - Current: FPS--ES--Open DoorsKermit NelsonNaNNaNHousehold with Adults and Children500.0Client may be seen by othersNaNNaNNaNNaN0.0NaN1NaNNaNNaNNaNNaNNaNNaNNaNNaN7th Grade or 8th GradeAttending school regularlyNaNNaNNaNNaNNaNNaNNaNNaNNaN12/03/2019 - Current: CC Partnership--RRH--Rehousing (CHG)NaNNaNNaNNaNYesNaNNaNNaNNaNNaNNaN
2024Family Promise of SpokaneFPS--ES--Open DoorsEmergency shelterNight-by-Night (nbn)NaN2019-11-29NaTNaNSonNaNRickyAntenFull SSNXXX-XX-07192009-06-30Full DOB ReportedNative Hawaiian or Other Pacific IslanderNon-Hispanic/LatinoMaleNaNNoNaTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaTNaNClient doesn't knowYesNaNNaNNaN00Yes7478012492010.002.01230False111/27/2019 - Current: CC--CA-HFCA22.010.02019-12-04 21:12:14.183NaT2019-11-29NaT2019-11-305No Engagement DateNo Move-In Date11/29/2019 - Current: FPS--ES--Open DoorsKermit NelsonNaNNaNHousehold with Adults and Children500.0Client may be seen by othersNaNNaNNaNNaN0.0NaN1NaNNaNNaNNaNNaNNaNNaNNaNNaNNursery School to 4th GradeAttending school regularlyNaNNaNNaNNaNNaNNaNNaNNaNNaN12/03/2019 - Current: CC Partnership--RRH--Rehousing (CHG)NaNNaNNaNNaNYesNaNNaNNaNNaNNaNNaN